Add optional statements to SQL builder like COLLATE
Posted 08 December 2011 - 06:26 AM
At the moment this is not possible using the query builder unless you write you own plain sql query.
I think it would be a good idea to add a method like collate() or something generic like additional() (or something like that) that allow to attach non standard statements like COLLATE to the generated query.
I hope I have been clear enough explaining the case.
Posted 09 December 2011 - 05:19 AM
From a simple google search, this is what I have found:
Posted 28 December 2012 - 10:59 AM
Or different sorting options like
SORT BY row DESC NULLS LASTfor example.
I think that would be quite useful.