Locoia
Search…
Writing SQL Queries

Available Functions

Following the the available functions and autocomplete terms that you can use inside your SQL queries
    #>
    #>>
    $end_date
    $start_date
    *
    ->
    ->>
    ::
    <
    >
    AND
    AS
    ASC
    AVG
    BTRIM
    CASE
    CAST
    COALESCE
    CONCAT
    CONCAT_WS
    COUNT
    CURRENT_DATE
    DATE
    DATE_PART
    DATETRUNC
    DESC
    DISTINCT
    ELSE
    END
    FALSE
    FLOAT
    FROM
    FULL OUTER JOIN
    GENERATESERIES
    GROUP BY
    IFNULL
    ILIKE
    INITCAP
    INNER JOIN
    INT
    INTERVAL
    JSON
    LEFT OUTER JOIN
    LEFT
    LENGTH
    LIKE
    LIMIT
    LOWER
    LPAD
    LTRIM
    NOT ILIKE
    NOT LIKE
    NULL
    ON
    OR
    ORDER BY
    REGEXP_MATCHES
    REGEXP_REPLACE
    REPEAT
    REPLACE
    REVERSE
    RIGHT OUTER JOIN
    RIGHT
    RPAD
    RTRIM
    SELECT
    SPLIT_PART
    SUBSTRING
    SUM
    TEXT
    THEN
    TIMESTAMP
    TRUE
    UNION ALL
    UNION
    UPPER
    WHEN
    WHERE
Last modified 1mo ago
Copy link