Sql utils class

[BenoitSafari]

Scope

• Created a template string function that returns a postgres query object
• Created a class that interface db calls

Examples

// Function call
const query = sql`SELECT * FROM users WHERE id = ${107};`;
// Returns
{ 
  text: 'SELECT * FROM users WHERE id = $1;',
  values: [108]
}

VS Code provides syntax highlighting.

_See https://developer.mozilla.org/en-US/docs/Web/JavaScript/Reference/Template_literals#tagged_templates_