Expressions, Functions, Operators

Statements

Component
Supported
Notes and limitations
Common statements

Clauses

Component
Supported
Notes and limitations
WHERE
HAVING
LIMIT
OFFSET
GROUP BY
Group-by columns can be referred to by their ordinal (e.g. 1, 2), a MySQL dialect extension.
ORDER BY
Order-by columns can be referred to by their ordinal (e.g. 1, 2), a MySQL dialect extension.
Aggregate functions
DISTINCT
ALL

Table expressions

Component
Supported
Notes and limitations
Tables and views
Table and view aliases
Joins
LEFT OUTER, RIGHT OUTER, INNER, NATURAL, and CROSS JOINS are supported. FULL OUTER joins are not supported.
Subqueries
UNION

Scalar expressions

Component
Supported
Notes and limitations
Common operators
IF
CASE
NULLIF
COALESCE
IFNULL
AND
OR
LIKE
IN
INTERVAL
Scalar subqueries
Column ordinal references

Functions and operators

Currently supporting 152 of 438 MySQL functions.
Most functions are simple to implement. If you need one that isn't implemented, please file an issue. We can fulfill most requests for new functions within 24 hours.
Component
Supported
Notes and limitations
%
&
`
*
+
->>
->
-
/
:=
<<
<=>
Null-safe equals operator
<=
<>, !=
<
=
>=
>>
>
^

Aggregate Functions

Refer to the MySQL Aggregate Function Documentation for more info.
Component
Supported
Notes and limitations
AVG()
BIT_AND()
BIT_OR()
BIT_XOR()
COUNT()
COUNT(DISTINCT)
GROUP_CONCAT()
JSON_OBJECT_AGG()
JSON_ARRAY_AGG()
MAX()
MIN()
STD()
STDDEV()
STDDEV_POP()
STDDEV_SAMP()
SUM()
VAR_POP()
VAR_SAMP()
VARIANCE()

Window Functions

Refer to the MySQL Window Function Descriptions for more info.
Component
Supported
Notes and limitations
CUME_DIST()
DENSE_RANK()
FIRST()
FIRST_VALUE
LAG
LAST_VALUE()
LAST()
LEAD()
NTH_VALUE()
NTILE()
PERCENT_RANK()
RANK()
ROW_NUMBER()