nodejs-bigquery icon indicating copy to clipboard operation
nodejs-bigquery copied to clipboard

Use Template Strings for GoogleSQL raw queries

Open MatthewAry opened this issue 1 year ago • 1 comments

Is your feature request related to a problem? Please describe. DX can be improved by adding support for writing raw GoogleSQL queries using a template literal tag. This is a convenient way to write statements while mitigating risks of sql injection attacks.

Describe the solution you'd like For details on what this is please see:

  • https://vercel.com/docs/storage/vercel-postgres/sdk#sql
  • https://developer.mozilla.org/en-US/docs/Web/JavaScript/Reference/Template_literals#tagged_templates

Describe alternatives you've considered I've considered using a third party solution for a different flavor of SQL, but there is a risk that it can have unexpected or undesirable results.

Thank you.

MatthewAry avatar Mar 14 '24 18:03 MatthewAry

@MatthewAry thanks for the suggestion, that's a really nice feature to add to our library. I'll take a look on adding that after some other improvements that I'm working right now (mainly speeding up query execution with #1337)

alvarowolfx avatar Mar 15 '24 14:03 alvarowolfx