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