Chris Swenson

Improve expand/modify experience for nested queries, including expansion, add limit, filter, or ordering

2

Today, we cannot add limits, filters, or orderings to nested queries without first duplicating them. This is due to a limitation of the Malloy structdef format in which a refinement...

`index:` queries currently generate columns `fieldName`, `fieldValue`, and `fieldType`. Everywhere in Malloy documentation we use snake case names by convention. So we should probably change these to be `field_name`, `field_value`,...

``` sql: one_sql is { select: """SELECT 1 as one""" connection: "bigquery" } query: from_sql(one_sql) -> { project: * calculate: s is lag(one) } ``` Error: `PROJECT cannot be used...

Can't add a stage to a nested query

1

1. Nest a query 2. Duplicate it (unless you created the query with "New Nested Query") 3. Try to add a stage to it 4. Boom

_I'm not 100% sure about this behavior yet, so adding the DO NOT MERGE label, and this implementation also feels a bit icky in a way I can't put my...

Snowflake pool sometimes persists a temporary table in one session then attempts to access it in another session

1

There does not seem to be any system in place to make sure that, for a single Malloy compile, the Snowflake connection only uses one session. Because of this, when...

In a query like: ```malloy run: something -> { group_by: thing aggregate: stuff order_by: stuff nest: cool_chart calculate: n is row_number() } ``` We generate SQL like: ```sql WITH __stage0...

FROM TODO: https://github.com/malloydata/malloy/blob/main/test/src/databases/all/parameters.spec.ts#L90-L94 Excepting a field outright removes it from the source, without consideration to other fields that use that removed field in their definition. Since those other fields have...

From TODO https://github.com/malloydata/malloy/blob/main/packages/malloy/src/lang/doc/param-internal.md?plain=1#L6 With the new parameters design, the old internal parameters documentation is outdated. Update it.