解析JSON：

1

SELECT CAST(json_extract(field, '$.json_path') AS string)

正则匹配

1

SELECT regexp_like('text', 'regex')

定义查询变量

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11

WITH VARIABLES AS
    (
        SELECT '2022-11-01' AS mdt, '2022-11-31' AS edt
    )
SELECT
    a1column
FROM
    app.table a
INNER JOIN VARIABLES
ON
    a1dt >= VARIABLES.mdt AND a.dt <= VARIABLES.edt