Specifying Offset in LIMIT Clause

Why it matters

This feature allows users to specify an offset in the LIMIT clause using the more standard LIMIT n OFFSET m syntax, improving SQL compatibility and making queries more readable and familiar for those coming from other SQL databases.

How to use it

Users can replace the existing LIMIT n, m syntax with the equivalent LIMIT n OFFSET m syntax in their queries, for example:

SELECT * FROM table_name LIMIT 10 OFFSET 20