SQL Query working differently in playground vs SDK

const subquery = `SELECT DISTINCT (o.id)
                        FROM transactions t,
                             orders o
                        WHERE t.report = '${report_id}'
                          AND t.order = o.id`;

      const total_amounts = await this.dbClient.sql<{
        total_invoiced: number,
        total_commission: number;
      }>`SELECT SUM(orders.total_price) AS total_invoiced, SUM(orders.total_commission) AS total_commission
         FROM orders
         WHERE orders.id in (${subquery})`;

{
  records: [ { total_commission: null, total_invoiced: null } ],
  rows: undefined,
  warning: undefined,
  columns: [
    { name: 'total_invoiced', type: 'float8' },
    { name: 'total_commission', type: 'float8' }
  ]
}

SELECT SUM(orders.total_price) AS total_invoiced, SUM(orders.total_commission) AS total_commission
         FROM orders
         WHERE orders.id in (SELECT DISTINCT (o.id)
                        FROM transactions t,
                             orders o
                        WHERE t.report = 'rec_REDACTED'
                          AND t.order = o.id)

{
  "records": [
    {
      "total_commission": 2271.84,
      "total_invoiced": 28398
    }
  ],
  "columns": [
    {
      "name": "total_invoiced",
      "type": "float8"
    },
    {
      "name": "total_commission",
      "type": "float8"
    }
  ],
  "total": 0
}