malloy
malloy copied to clipboard
Turducken: Add the ability to run a sql: block in VSCode
In VSCode I would like to be able to run a SQL block. We should also allow this from malloy.ts.
The use case here are sql blocks for transformation.
sql: make_stuff is {
select: """CREATE TABLE stuff AS ({% make->stuff %})"""
connection: "bigquery"
}
If we did something like this, it would probably be
sql: {
ddl: SQL_STRING
connection: ...
}
No "name" would be allowed and you wouldn't use select:
... and ... ugh ... it's at least a day to get it working, it breaks everything I just did.
I'd rather see this in the command line tool which lets you embed Malloy in an SQL file.
this is done, right?