Query Templates

SQL Query Template Objects

SQL Query templates can be used to create SQL Query object with predefined properties.

Creating SQL Query Template objects

While SQL Query Template objects can be created via the sqlquerytmpl_createObject API, it is simpler to create them in a query templates.yml file. You can see a list of the available object properties by referring to the sqlquerytmpl_set documentation.

Here is some example YAML for creating SQL Query Template objects:

query templates:
  - name: next sequence in project
    select clause: MAX(sequence)