SQLite.swift
SQLite.swift copied to clipboard
Add order by NULLS FIRST/LAST
Would be great to have the ability to add custom expressions so we can add different things that aren't covered in the library already. For example, I need to run a ORDER BY "fieldName" IS NULL, but there is no such expression available for the fields. Is there another way to do this without running custom SQL?
SQLite 3.30.0 supports NULLS FIRST
and NULLS LAST
, so this should probably be added instead
https://sqlite.org/lang_select.html