14 Commits (main)

Author	SHA1	Message	Date
Kyle Brandt	92a6faeff2	SQL Expressions: Add Functions to Allow list (#113291) ... Add assorted math, windowing, json, date/time, regex, string, conditional, and aggregation functions to allow list	3 months ago
Kyle Brandt	4f0cb47d3c	SQL Expressions: Rework backend errors and error instrumentation (#109633) ... * Capture error_type label on metrics/traces * Make error messages more helpful to user * Use errutil, categorized errors, and tie them to error_type (category in code) * Misc trace fixes * Add metric to track SQL input conversion	5 months ago
Sam Jewell	f8a72214cf	SQL Expressions: Add more functions to the allowlist (#103546) ... * SQL Expressions: Allow many more functions and nodes * Also allow the `REGEXP_SUBSTR` function * Add window functions * add more JSON support, remove now and current time (for now) --------- Co-authored-by: Kyle Brandt <kyle@grafana.com>	10 months ago
Kyle Brandt	856dcfd6fe	SQL Expressions: Permit range conditions (between) in queries (#103238)	10 months ago
Sam Jewell	af08a9fae2	SQL Expressions: Add JSON support (#103157) ... - Support bi-directional mapping of frame JSON fields and GMS (go-mysql-server) columns - Permit GMS json functions Co-authored-by: Kyle Brandt <kyle@grafana.com>	10 months ago
Kyle Brandt	e6480a050c	SQL Expressions: Allow substring_index func (#103021)	10 months ago
Sam Jewell	c9e929e2e6	SQL Expressions: Allow more MySQL AST node-types (#102973) ... * SQL Expressions: Add Null-literal node * Retain some order in the code - put NullVal with BoolVal * Add support for `IN` keyword * Add GROUP_CONCAT keyword * Add COLLATE keyword From Claude: The test case demonstrates a simple use of COLLATE with a string literal, but in real MySQL queries, COLLATE is often used in more complex scenarios like: 1. String comparisons: `SELECT * FROM table WHERE name COLLATE utf8mb4_bin = 'John'` 2. Sorting: `SELECT * FROM table ORDER BY name COLLATE utf8mb4_unicode_ci` 3. JOINs: `SELECT * FROM table1 JOIN table2 ON table1.name COLLATE utf8mb4_bin = table2.name` The COLLATE clause is particularly useful when you need case-sensitive comparisons (utf8mb4_bin) or specific language-aware sorting rules.	10 months ago
Sam Jewell	6be7829acf	SQL Expressions: Allow `IS` keyword (#102841)	10 months ago
Kyle Brandt	0f6aff2057	SQL Expressions: allow ParenSelect in queries (#102807) ... sql_expressions: allow ParenSelect	10 months ago
Sam Jewell	21b9d45ca6	SQL Expressions: Add CASE/WHEN nodes and fixes (and test) for functions just added to allowlist (#102040) ... * SQL Expressions: Add CASE/WHEN SQL nodes to allowlist * Fixed and test for functions added in #102011 * Add remaining functions to the test-case These are mostly aliases, so the LLM chose to omit them originally. But adding now for completeness * Fix ordering of allowed nodes	10 months ago
Sam Jewell	4bd5f29e05	SQL Expressions: Allow more functions (#102011) ... I used Cursor and Claude 3.7 thinking to expand the list of functions we allow. Specifically I needed `abs`. TODO: Check each of these in the official MySQL docs to ensure they are all safe: eg. this doc: https://dev.mysql.com/doc/refman/8.4/en/flow-control-functions.html#operator_case	10 months ago
Kyle Brandt	6dc98dbbcc	SQL Expressions: Add str_to_date function and unskip test (#100226)	12 months ago
Kyle Brandt	d196b789e2	SQL Expressions: Add more SQLNodes and funcs to allow list (#100227) ... sql_expr: Add more Nodes and funcs to allow list	12 months ago
Kyle Brandt	d64f41afdc	SQL Expressions: Re-implement feature using go-mysql-server (#99521) ... * Under feature flag `sqlExpressions` and is experimental * Excluded from arm32 * Will not work with the Query Service yet * Does not have limits in place yet * Does not working with alerting yet * Currently requires "prepare time series" Transform for time series viz --------- Co-authored-by: Sam Jewell <sam.jewell@grafana.com>	12 months ago