Which problem is this feature request solving?
I would like to write the DDL that will be executed to files, without executing them on the destination.
This will allow for:
- inspection before executing on the destination
- executing them manually or out-of-band on the desintation as-is
- allow for modifications before executing (like additional indexes, etc)
An example is given GCP source and Postgresql destination configs, write the SQL to create the tables files without creating/migrating the tables and without syncing.
Describe the solution you'd like
Perhaps adding "ddl" or "native" format to the --format flag.
cloudquery tables ./directory --filter spec --format native
The output is whatever code is generated to create the destination object (table, etc).
- postgresql would emit SQL
- etc
Pull request (optional)