Roenbaeck/anchor

Feature - create 'common' templates - uni temporal

delostilos opened this issue · 1 comments

Create a set of templates that can be used by PostgreSQL and derived/common dialects:

  • PostgreSQL >12
  • Snowflake
  • Vertica

Later maybe also for:

  • Redshift
  • DuckDB
  • Citus

Add to 'Common':

  • Oracle
  • Teradata

The idea is that the small differences can be coded with conditional if/switch statements and we have less templates to maintain.
This is mainly for the creation of database tables and views. Table value functions are coded by dialect still.

Changed the name to Common templates and made some changes, so we can also add Oracle and Teradata to the Common set of templates.