Error "For SELECT DISTINCT, ORDER BY expressions id must appear in select list" may be over eager

[alamb]

#5132 added a check that made certain SQL queries error rather than give wrong results (❤️ thanks to @xiaoyong-z !)

However, the way the check is implemented is to match the pattern built by the sql planner for this kind of query. However, if the query is built directly (via a DataFrame or someone using LogicalPlanBuilder directly) it is probably incorrect to throw an error here (as they may have meant to to run the distinct before the sort for some reason)

cc @alamb

Originally posted by @liukun4515 in #5132 (comment)