sql.json - filter parameter missing? · porsager/postgres · Discussion #406

vitalyster
Jun 23, 2022

JSON.stringify have second filter parameter, what about sql.json? Any different way to transform object before writing to the database?

Answered by porsager

sql.json isn't necessary for v3. Just use regular Javascript ;)

sql`
 insert into x (some_json) values (${
 someArray.filter(x => x.some_prop === 'wat')
 }::jsonb)
`

sql.json isn't necessary for v3. Just use regular Javascript ;)

sql`
 insert into x (some_json) values (${
 someArray.filter(x => x.some_prop === 'wat')
 }::jsonb)
`

0 replies

Answer selected by porsager