Panache - Support specifying whether NULLs come first or last when using Sort

[josephearl]

Description

When using ORDER BY in SQL you can specify where nulls should appear using NULLS FIRST or NULLS LAST, e.g. ORDER BY x DESC NULLS LAST

It would be nice to have this functionality available when using Sort.by and Sort.ascending etc.

Implementation ideas

Add directions ASCENDING_NULLS_FIRST, ASCENDING_NULLS_LAST, DESCENDING_NULLS_FIRST ... etc

Add shortcuts Sort.ascendingNullsFirst, Sort.ascendingNullsLast ... etc

[Sgitario]

This has been recently implemented in #26394.

Example: Sort.by("foo", Sort.NullPrecedence.NULLS_FIRST);

[josephearl]

Awesome, in which case this can be closed