grafana

Commit Graph

Author	SHA1	Message	Date
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>	3 months ago
Kyle Brandt	856dcfd6fe	SQL Expressions: Permit range conditions (between) in queries (#103238 )	3 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>	3 months ago
Kyle Brandt	e6480a050c	SQL Expressions: Allow substring_index func (#103021 )	3 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.	3 months ago
Sam Jewell	6be7829acf	SQL Expressions: Allow `IS` keyword (#102841 )	3 months ago
Kyle Brandt	0f6aff2057	SQL Expressions: allow ParenSelect in queries (#102807 ) sql_expressions: allow ParenSelect	3 months ago
Todd Treece	1b1f626edd	SQL Expressions: Fix error handling (#102650 )	3 months ago
Sam Jewell	d7aeebe5e3	Sql Expressions: State when error is from GMS (#102112 )	3 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	4 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	4 months ago
Kyle Brandt	4d7b9a3c77	SQL Expressions: Improve response to frame conversion handling (#100625 ) - use types.Convert to get a more normalized type returned from GMS. After syncing with GMS maintainers, the underlying type of the row could be different things (e.g. int when unit32, so this calls the Convert method from the GMS types library to normalize the interface. - Clean up fieldValFromRow more - Use IsText to capture different string types - Add more types to test, also update test to use same cmp.Diff method as others --------- Co-authored-by: Sam Jewell <2903904+samjewell@users.noreply.github.com>	4 months ago
Kyle Brandt	f7588376df	SQL Expressions: (Chore) Update code for latest plugin-sdk data pkg (#100425 ) Use new NilAt and SetRefId methods	5 months ago
Kyle Brandt	6dc98dbbcc	SQL Expressions: Add str_to_date function and unskip test (#100226 )	5 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	5 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>	5 months ago
Sam Jewell	1915efbc95	SQL Expressions: Simplify where code is being stubbed out (#96227 ) * Rename from DuckDB * Remove unused function	7 months ago
Sam Jewell	ea71201ddc	ServerSideExpressions: Disable SQL Expressions to prevent RCE and LFI vulnerability (#94942 ) * disable sql expressions remove duckdb ref * Run `make update-workspace` --------- Co-authored-by: Scott Lepper <scott.lepper@gmail.com>	8 months ago
Scott Lepper	cac40795a5	sql expressions - logging (#88193 ) * sql expressions - logging	1 year ago
Scott Lepper	93acc0c932	sqlexpressions - fix escape quote (#87921 )	1 year ago
Scott Lepper	14a814a280	[sql expressions] fix: use ast to read tables (#87867 ) * [sql expressions] fix: use ast to read tables * can't run tests during ci yet. need to install duckdb * skip for now. need duckdb cli	1 year ago
Scott Lepper	1a2bbd61fd	sql expressions: improve parser (#87277 ) sql expressions: improve parser	1 year ago
Scott Lepper	cbe3e3a5e0	fix: sql expressions parser with join (#87263 )	1 year ago
Scott Lepper	4fd2cb6014	fix: sql expressions - sql parser table name case (#87196 ) * fix: sql parser table name case	1 year ago
Scott Lepper	70009201d4	Expressions: Sql expressions with Duckdb (#81666 ) duckdb temp storage of dataframes using parquet and querying from sql expressions --------- Co-authored-by: Ryan McKinley <ryantxu@gmail.com>	1 year ago

25 Commits (103652-docs-alert-migration-tool)