v2 feedback, would be nice to add custom alternatives to "NOWAIT". I want to add postgres's "SKIP LOCKED".
How can I do ORDER BY x is not null
?
@dominicm The latter just came up here https://github.com/seancorfield/honeysql/issues/285 (v2 makes this easier than v1 but it's possible in both).
and I created https://github.com/seancorfield/honeysql/issues/286 for your other issue https://github.com/seancorfield/honeysql/issues/286
Calling :=... weird, but it kinda makes sense if I squint :p.
There's an :is-not
operator if you prefer 🙂
I think it just violates my expectations based on what works in :where
I can see you're aware of that for honeysqlv2 though
I'm quite excited to try and write postgres-honeysql2 :)
(or maybe it won't be needed)
It shouldn't be needed since I plan to add all of PG to HoneySQL directly, over time anyway. Even if some of it has to go into a :postgresql
dialect (v2 has dialect support builtin).