postgresql.js

// filtering something by its lifetime with slonik
const filterByLifetimeQuery = sql`
select id
from eventlog
where
  code=${code} and
  payload=${sql.json(payload)} and
  created_at + interval '1 second' * ${parseInt(ctx.threshold)} > now()
`

// remove properties from jsonb field
const updateFieldQuery = sql`
update methods
set
  credentials = credentials - '{password,salt}'::text[],
  status='ACTIVE'
where id=${method.id}
`

// get timestamp for a future date
const tokenLife = '3 hours'
const willExpireAtQuery = sql`
SELECT to_timestamp(${Date.now()/1000}) + ${tokenLife}::interval as date;
`