Order by using computed column

[amosyuen]

When using mariadb dialect I try to order by a computed column, it instead tries to get the literal column on the table.

For example I have a computer column distance, trying to get that column and use it to order the table I get a query like this:

SELECT
  (ST_Distance(`homeConnec`.`lngLat`, POINT(0,0))) AS `distance`
FROM (
  SELECT `homeConnec`.*, count(*) OVER () AS `$total`
  FROM Home `homeConnec`
  ORDER BY `homeConnec`.`distance` ASC
) `homeConnec`
ORDER BY `homeConnec`.`distance`

Which throws an error Unknown column 'homeConnec.distance' as expected.

[amosyuen]

I'm curious why it does a nested query for something that could easily be done without the nested query.

As far as I can tell there are two things that need to be done:

1. Don't use the table prefix for computed columns in orderBy
2. Either get rid of the nested query or also select the computed columns in the nested query

[amosyuen]

Created #324 to address this

[arthurlataks]

Is there any chance this PR will be merged?

[nicoabie]

Please provide running example using https://github.com/join-monster/join-monster-sscce