db
db copied to clipboard
Lexicographic sort
Hello, I want to perform a lexicographic ORDER BY in SQL via upper.io. In raw SQL, this is accomplished with ORDER BY LENGTH(<field>), <field>. However, upper.io's API does not appear to allow non-field inputs to the Collection OrderBy() method.
How can we improve the API to allow for fields to be sorted lexicographically for a more natural feel?