lake-query

From README

Lake Query oleander routes the query. It parses the SQL, estimates how much data the referenced tables hold, and picks the engine and machine size to match. Pick the tool by whether the query changes data — not by how big it is. | Tool | Use for | | --- | --- | | queryrun | Reads. Rows come back on the call. | | querysubmit | Anything that changes data, and reads too large to return interactively. | | sparksqlsubmit | Spark jobs needing a durable job name or explicit machine types. | Leave engine as auto unless the user asked for a specific one. Every response carries enginedecision; use its reasons when telling the user why a query ran the way it did. Reads — queryrun queryrun is read-only and enforces it: INSERT, UPDATE, DELETE, MERGE, CREATE, ALTER, DROP, and TRUNCATE are rejected before the request goes out. That is what makes its readOnlyHint true, so clients can skip the confirmation prompt.