Writing SQL Queries
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"
.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 1yr ago