How should Metabase add/modify/remove the sorting of columns in a free-text query?
Also, what if the query contains sub-selects and other advanced queries, what should be changed there?
Note that the syntax of the query depends on whatever database/driver you are querying.
The workaround is to use Saved Questions, so the users never mess around with queries, but just use the interface.
There are several caveats with Saved Questions, but in this specific case, I think it would work great.
Another workaround is to show the SQL question on a dashboard, since it allows client-side sorting on dashboards.
Just for references, if you’re interested reading more about why it’s difficult to implement:
Also, feature requests and bug reports are on Github. This forum is for questions, troubleshooting and anything else