Support ordering by nested columns deeper than one level in .order()

Feature request Is your feature request related to a problem? Please describe. Currently, .order() in supabase-js only supports ordering by nested relations one level deep. For example: This works as expected and orders the customers table globally by accounts.full_name. However, when trying to order by a column that is more than one level deep (grandchild relation), it fails. Example: This does not work because .order() does not support nested paths beyond one level. Describe the solution you'd like It should be possible to order a parent table by a nested column at any depth of relation (not just the immediate child). For example, the following should work: This would order connections globally by accounts.full_name via the customers relation. Describe alternatives you've considered • Creating SQL views that flatten the join and expose the nested column at the top level, then ordering by that column. • Writing RPC functi…