What pain point is this feature intended to address? Please describe.
DDL/DML are generally considered a part of SQL. We should consider adding support (via Vizual operations) for DDL/DML-style operations via SQL cells.
Describe the solution you'd like
Allow users to perform the following operations in a SQL cell (possibly multiple, separated by semicolons)
CREATE TABLE -> translate into an inline table with no rows
UPDATE TABLE -> translate into a view definition a'la Vizual
INSERT INTO -> translate into a UNION query
DELETE FROM -> translate into a SELECT FROM WHERE view definition
ALTER TABLE ADD COLUMN -> SELECT FROM
ALTER TABLE DROP COLUMN -> SELECT FROM
maybe others?
Describe alternatives you've considered
Most of these operations can be replicated via Vizual or spreadsheet commands.
What pain point is this feature intended to address? Please describe. DDL/DML are generally considered a part of SQL. We should consider adding support (via Vizual operations) for DDL/DML-style operations via SQL cells.
Describe the solution you'd like Allow users to perform the following operations in a SQL cell (possibly multiple, separated by semicolons)
CREATE TABLE
-> translate into an inline table with no rowsUPDATE TABLE
-> translate into a view definition a'la VizualINSERT INTO
-> translate into aUNION
queryDELETE FROM
-> translate into aSELECT FROM WHERE
view definitionALTER TABLE ADD COLUMN
->SELECT FROM
ALTER TABLE DROP COLUMN
->SELECT FROM
Describe alternatives you've considered Most of these operations can be replicated via Vizual or spreadsheet commands.