As I've been continuing with https://github.com/seancorfield/honeysql/blob/v2/doc/clause-reference.md I've also been fixing a few bugs I've run across and also adjusting a few things to make usage easier (e.g., :with
for CTE no longer requires the extra wrapping as a sequence since there can only ever be one WITH
clause in an expression as far as I can tell from the SQL Server docs, although it still accepts the old 1.x format; :order-by
now allows the direction to be omitted when you order by an expression although it still needs to be wrapped to disambiguate it).