"LengthFunction.NAME"   copy paste?

I had a skim over the patch.. Seems the SQL syntax is not exactly like Oracle.  Mind specifying the syntaxt?  For LAST_VALUE how specify the range?