Writing SQL Queries

SQL-Dialect
The SQL dialect used is Postgres. You can find a detailed description of how to create queries here: https://www.postgresql.org/docs/current/queries.html.
In PostgreSQL unquoted names are case-insensitive. This means that SELECT * FROM mytable and SELECT * FROM myTable are equivalent and both tables are interpreted as mytable.
However, quoted names are case-sensitive. So in case there is any casing in either your table or column names you should use quotes, e.g. SELECT * FROM "myTable".
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

Insight Marketplace - Using Pre-Built Insights

Useful SQL Examples

Last modified 2mo ago

Copy link

Contents

SQL-Dialect

Available Functions