Bringing PRQL into TypeScript

prql.ts

prql
  .query()
  .from('invoices')
  .derive({
    transaction_fee: 0.8,
    income: 'total - transaction_fee',
  })
  .filter('income', '>', 5)
  .filter('invoice_date', '>=', '@2010-01-16')
  .group('customer_id', {
    aggregate: {
      sum_income: 'sum income',
      ct: 'count customer_id',
    },
  })
  .join('c', 'customers (==customer_id)')
  .derive('name', f`{c.last_name}, {c.first_name}`)
  .derive('db_version', s`version()`)
  .select('c.customer_id', 'name', 'sum_income', 'ct', 'db_version')
  .sort('-sum_income')
  .take(1, 10)