Hey. I'm trying to do

query.orderBy(column)

This column is a string column, and I want the

orderBy

statement NOT to be case sensitive. How can I achieve that? (without changing the column altogether to

.lowercase()

https://stackoverflow.com/questions/2413427/how-to-use-sql-order-by-statement-to-sort-results-case-insensitive/2413833 alas, that's just the way it is. I did not find a ready-made collate operator, but you can write it

MyTable.selectAll()
   .orderBy(MyTable.name.lowerCase())

You're correct. That's the way to do it! Thank you 😄