CaseTalk:15/SQL DDL
From CaseTalk Wiki
CaseTalk version 15 supports SQL DDL generation for 22 relational and NoSQL database platforms through its template-based code generation engine. Each template produces platform-specific DDL scripts from the validated conceptual model.
Relational Databases
| Target | Template | Output | Notes |
|---|---|---|---|
| ISO SQL-92 | sql92.ini | .sql | ANSI-standard DDL baseline |
| ISO SQL:2011 | sql2011.ini | .sql | Temporal tables, enhanced types |
| Microsoft SQL Server 2016 | mssql2016.ini | .sql | T-SQL specific syntax |
| PostgreSQL | postgresql_schema.ini | .sql | PostgreSQL-specific types and syntax |
| MySQL 8 | mysql_schema.ini | .sql | InnoDB engine, MySQL 8 features |
| MariaDB 10 | mariadb.ini | .sql | MariaDB-specific extensions |
| Oracle 23c | oracle23c.ini | .sql | Oracle PL/SQL syntax |
| SQLite | sqlite.ini | .sql | Lightweight embedded database |
| Interbase / Firebird | firebird.ini | .sql | Firebird SQL dialect |
| IBM Db2 | db2.ini | .sql | IBM Db2 syntax |
| Teradata | teradata.ini | .sql | Teradata-specific DDL |
| MS Access 2016 | msaccess2016.ini | .sql | MS Access SQL dialect |
Cloud Data Warehouses
| Target | Template | Output | Notes |
|---|---|---|---|
| Google BigQuery | bigquery.ini | .sql | BigQuery SQL dialect |
| Snowflake | snowflake.ini | .sql | Snowflake cloud data platform |
| Amazon Redshift | redshift.ini | .sql | Redshift SQL syntax |
| Databricks SQL | databricks.ini | .sql | Delta Lake / Databricks |
| ClickHouse | clickhouse.ini | .sql | Column-oriented analytics |
| DuckDB | duckdb.ini | .sql | In-process analytics |
| SAP HANA | sap_hana.ini | .sql | SAP HANA SQL dialect |
NoSQL / Document Databases
| Target | Template | Output | Notes |
|---|---|---|---|
| Apache Cassandra | cassandra.ini | .cql | CQL DDL for Cassandra |
| MongoDB | mongodb.ini | .js | MongoDB shell scripts |
| Elasticsearch | elasticsearch.ini | .json | Index mapping definitions |
How to Use
- Open a validated conceptual model
- Choose Generate → [Target Database] from the menu
- Configure output directory and options in the generation dialog
- Click Generate to produce DDL scripts
Templates can be customized through Custom SQL Rules and Custom SQL Script for project-specific requirements. The JCatalog provides the internal schema that feeds all SQL templates.
See Also
Other versions: v8 | v9 | v10 | v11 | v12 | v13 | v14 | v15
| Code Generation | |
|---|---|
| Dialogs | SQL DDL/DML · XML Schema · RichText · Generate Misc · Reverse Engineering |
| Version 15 | Overview · SQL DDL · Languages · Semantic Web · Data Engineering · Reports · Import · Integrations |
| Reference | Column Names · Custom SQL Rules · Custom SQL Script · Data Vault · JCatalog |