A query template is translated by dsqgen into fully functional SQL, which is known as executable query text (EQT).
The query templates are primarily phrased in compliance with SQL1999 core (with OLAP amendments).
A template includes the following, non-standard additions:
See tpcds_home\query_templates/*.tpl