4 ms·
Do you plan on adding capability to do more DDL and DML?
by hbarka 5y ago
Do you plan on adding capability to do more DDL and DML?
- dmoura 5y agoThe tool has a flow: stdin -> spyql -> stdout You can choose the data format of the input and output. One of the output formats writes INSERT statements to stdout, enabling to import data to any SQL database. Currently, spyql does not have the option to generate a `CREATE TABLE` statement, but that is planned, as well as what to do with already existing data/tables (e.g. drop, truncate, ignore). I wonder if UPDATEs and UPSERTs would also be useful, but haven't put much though into it, any feedback here would be welcomed.