An AS OF clause is part of a flashback query, which provides ways to view
past states of database objects, or to return database objects to a previous state, without using
traditional point-in-time recovery.

This DateTimeFactory creates a new DateTime when the portion of the query to
parse starts with CURRENT_DATE, CURRENT_TIME, CURRENT_TIMESTAMP or with the
JDBC escape format used for date/time/timestamp.

An orderby_item must be one of the following:
A state_field_path_expression that evaluates to an orderable
state field of an entity or embeddable class abstract schema type designated in the SELECT clause
by one of the following:
A general_identification_variable
A single_valued_object_path_expression
A state_field_path_expression that evaluates to the same
state field of the same entity or embeddable abstract schema type as a state_field_path_expression in the SELECT clause
A result_variable that refers to an orderable item in the SELECT
clause for which the same result_variable has been specified.