malloy icon indicating copy to clipboard operation
malloy copied to clipboard

Turducken: Add the ability to run a sql: block in VSCode

Open lloydtabb opened this issue 2 years ago • 2 comments

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"
}

lloydtabb avatar Dec 05 '22 18:12 lloydtabb

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.

mtoy-googly-moogly avatar Dec 05 '22 18:12 mtoy-googly-moogly

this is done, right?

mtoy-googly-moogly avatar Sep 22 '23 17:09 mtoy-googly-moogly