Open cmcnicoll opened 5 months ago
From pg-promise docs:
When a query method is parameterized with values as an object, the formatting engine expects the query to use the Named Parameter syntax $*propName*
, with *
being any of the following open-close pairs: {}
, ()
, <>
, []
, //
.
// We can use every supported variable syntax at the same time, if needed:
await db.none('INSERT INTO users(first_name, last_name, age) VALUES(${name.first}, $<name.last>, $/age/)', {
name: {first: 'John', last: 'Dow'},
age: 30
});
Here is the workaround I've been using:
example.sql
:
select * from users where id = '${id}'
I use sqlfmt for all my dbt projects. Thank you @tconbeer for creating this wonderful tool!
It would be great if sqlfmt could also support this:
Docs