How do you test your dynamic postgres.js-queries when writing them?

[BeGj]

How do people here test that your queries work when writing them? Any best practices perhaps? Especially when doing inserts or updates.
Currently i have to copy the query to pgadmin and remove all "porsager" ${} stuff. But is there a better tool that allows just copy pasting the quries right from js/ts and test it? I also test the endpoints when writing, but my logging setup in fastify should maybe allow for better debugging locally, so the actual errors are now clearly visible.

Sorry if the question is poorly formulated, and thank you for reading this question/discussion.

[mwannenmacher]

Hi @BeGj ,
We are working with safeQL https://safeql.dev and integration tests for testing queries

[BeGj]

Hi @BeGj , We are working with safeQL https://safeql.dev and integration tests for testing queries

So I just got to test it and it seems that safeql does not understand postgres.js dynamic queries. So the following for instance would give red line below the dynamic part since it is not valid by itself.

const res = await sql<{a: string}[]>`
select a from schemaname.potato
${ parameters.answer ? sql`left join schema2.farmer on farmer.id = potato.farmer_id` : sql`` }
--- just a stupid example...
`

ts-safeql/safeql#99
ts-safeql/safeql#101
Without dynamic query support it makes safeql pretty useless