Missing `ORDER BY ... NULLS FIRST | LAST`

kayak / pypika

PyPika is a python SQL query builder that exposes the full richness of the SQL language using a syntax that reflects the resulting query. PyPika excels at all sorts of SQL queries but is especially useful for data analysis.

http://pypika.readthedocs.io/en/latest/

Apache License 2.0

2.43k stars 292 forks source link

Missing `ORDER BY ... NULLS FIRST | LAST` #797

Open martijnthe opened 3 months ago

martijnthe commented 3 months ago

I'm trying to add NULLS FIRST or NULLS LAST to an ORDER BY, but I cannot figure out how to do this. Is this functionality missing?

Any hint on how to best implement it? I'd be more than happy to craft a PR for pypika.