wren-engine
wren-engine copied to clipboard
`node-postgres` can't pass prepared statement parameters for LIMIT or OFFSET for BigQuery
node-postgres will pass all parameter as a VARCHAR data, no matter what type you input.
client.connect()
.then(() => {
const query = {
text: 'SELECT * FROM Model_Ticket LIMIT $1 OFFSET $2',
values: [100, 50],
};
return client.query(query);
})
However, BigQuery only accepts INTEGER literal for LIMIT or OFFSET statement.
"message" : "LIMIT expects an integer literal or parameter at [139:7]",
"status" : "INVALID_ARGUMENT"