Fork me on GitHub
#honeysql
<
2021-03-27
>
dcj16:03:18

If you want to format the query as a string with no parameters (e.g. to use the SQL statement in a SQL console), pass :inline true as an option to sql/format:
THANK YOU @seancorfield!!!

seancorfield17:03:42

There's also :pretty true simple_smile

dcj17:03:02

Already knew about :pretty but not about :inline which I needed, and was about to go manually inline a lot of cruft, and then while taking a shower this morning, it occured to me "wouldn't be awesome if sql/format did that", read the docs, and there it was!

1
orestis18:03:13

That’s a pretty nice feature! Is that honey sql 2 only? Very good reason to switch ASAP :)

seancorfield18:03:19

@orestis V2 only 🙂 Well, in theory the :parameterizer :none option in V1 did the same thing, except it didn’t work properly as I recall.