I'm trying to pass an array of items to a SELECT query and get all the rows back with those items. So far I've got it to work using a join method, but I'd prefer to just pass the array…
Is it possible for a single API PUT endpoint to use dynamic UPDATE/INSERT queries? Example: We have a patient table patient that has a first_name and last_name column. Sometimes we want to update the first name for a patient using…
In one of my projects, I want to execute 2 queries in parallel with pg-promise. I have these queries wrapped inside the transaction as added below. I am also using Promise.all() to make database calls in paralllel. I want to…