rawQuery not working on Production

[dmeinke-etc]

This is the query
const asset_based = await Database.rawQuery("SELECT min_payment , calc_payment, type, description, GREATEST(min_payment, calc_payment) as col_total FROM invoice_transactions WHERE type= 'asset_based' AND invoice_id = ?", [params.id]);

No error in dev but I get this error on production

{"level":50,"time":1678114208908,"pid":2024346,"hostname":"nodejs-ubuntu-s-1vcpu-1gb-intel-nyc1-01","name":"efinity","err":{"type":"Error","message":"SELECT min_payment , calc_payment, type, description, GREATEST(min_payment, calc_payment) as col_total FROM invoice_transactions WHERE type= \"asset_based\" AND invoice_id = '2' - Unknown column 'asset_based' in 'where clause'","stack":"Error: SELECT min_payment , calc_payment, type, description, GREATEST(min_payment, calc_payment) as col_total FROM invoice_transactions WHERE type= \"asset_based\" AND invoice_id = '2' - Unknown column 'asset_based' in 'where clause'\n at Packet.asError (/root/efinity/node_modules/mysql2/lib/packets/packet.js:728:17)\n at Query.execute (/root/efinity/node_modules/mysql2/lib/commands/command.js:29:26)\n at Connection.handlePacket (/root/efinity/node_modules/mysql2/lib/connection.js:456:32)\n at PacketParser.onPacket (/root/efinity/node_modules/mysql2/lib/connection.js:85:12)\n at PacketParser.executeStart (/root/efinity/node_modules/mysql2/lib/packet_parser.js:75:16)\n at Socket.<anonymous> (/root/efinity/node_modules/mysql2/lib/connection.js:92:25)\n at Socket.emit (node:events:390:28)\n at addChunk (node:internal/streams/readable:315:12)\n at readableAddChunk (node:internal/streams/readable:289:9)\n at Socket.Readable.push (node:internal/streams/readable:228:10)","code":"ER_BAD_FIELD_ERROR","errno":1054,"sqlState":"42S22","sqlMessage":"Unknown column 'asset_based' in 'where clause'","sql":"SELECT min_payment , calc_payment, type, description, GREATEST(min_payment, calc_payment) as col_total FROM invoice_transactions WHERE type= \"asset_based\" AND invoice_id = '2'","status":500},"msg":"SELECT min_payment , calc_payment, type, description, GREATEST(min_payment, calc_payment) as col_total FROM invoice_transactions WHERE type= \"asset_based\" AND invoice_id = '2' - Unknown column 'asset_based' in 'where clause'"}

Ive reversed the string quotes as weel th have the first part start with "SELECT... and also tried 'SELECT....

Is this some kind of configuration?

[dmeinke-etc]

I rewrote the query like this and it worked
"SELECT min_payment , calc_payment, type, description, GREATEST(min_payment, calc_payment) as col_total FROM invoice_transactions WHERE ?? = ? AND invoice_id = ?", ['type', 'asset_based', params.id]);