The SynthQL backend.
import { QueryEngine } from '@synthql/backend';
// Initialize the query engine
const queryEngine = new QueryEngine({
url: 'postgresql://user:password@localhost:5432/dbname',
});
// Write your query
const query = from('users')
.columns('id', 'first_name')
.filter({ id: { in: [1, 2, 3] } })
.all();
// Execute the query
const result = await queryEngine.executeAndWait(query);