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!!!There's also :pretty true
:simple_smile:
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!
That’s a pretty nice feature! Is that honey sql 2 only? Very good reason to switch ASAP :)
@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.