Lens withCount and sortable field fails on sort

[FN-FAL113]

• Laravel Version: 10
• Nova Version: 4.35
• PHP Version: 8.2
• Database Driver & Version: MySQL 8.0.33 (Docker Image)
• Operating System and Version: Windows 11
• Browser type and version: MS Edge
• Reproduction Repository:

Description:

When a query utilizes withCount and making a field sortable, the raw sql query that gets added by #sortable function prefixes an aliased subquery field with the table name which causes an error:
Error Code: 1054. Unknown column 'categories.products_count' in 'order clause'

I am not sure if the query is sql version dependent but I'm thinking that aliased fields should not be prefixed since its not a default table field.

Faulty

select `categories`.*, (select count(*) from `products` where `categories`.`id` = `products`.`category_id`) as `products_count` 
from `categories` order by `categories`.`products_count` asc;

Working

select `categories`.*, (select count(*) from `products` where `categories`.`id` = `products`.`category_id`) as `products_count` 
from `categories` order by `products_count` asc;

Detailed steps to reproduce the issue on a fresh Nova installation:

1. Create lens class

2. Define the query and filter just like in the image below and also making the aliased field sortable
   

3. Sort the field in the actual nova application in the browser