presto-docs/src/main/sphinx/release/release-0.185.rst
QueryCompletedEvent.ORDER BY
clause. For example: OVER (ORDER BY x ASC, x DESC).a JOIN b ON b.x < f(a.x) AND b.x > g(a.x)LAG) with similar specifications.!substr function to work on VARBINARY in addition to CHAR and VARCHAR.JSON to ROW.TRY within lambda expressions.