AS OFexpression must name a valid Dolt reference, such as a commit hash, branch name, or other reference. Timestamp / date values are also supported. Each table in a query can use a different
AS OFsyntax for
SELECTstatements, Dolt also supports an extension to the standard MySQL syntax to examine the database schema for a previous revision:
USEstatement. Note the backtick quoting, which is necessary since the database identifier contains a slash character.
AS OF, but works in some queries where the
AS OFsyntax is not supported.
dolt_historytables provide a row for every revision of a row in a table.