Added Connection.cache_stats() to provide more information about the statement cache.
Cursor.execute() now uses sqlite_prepare_v3 which allows supplying flags.
Cursor.execute() has a new can_cache parameter to control whether the query can use the statement cache. One example use is with authorizers because they only run during prepare, which doesn’t happen with already cached statements.
(The Cursor.execute() additional parameters are keyword only and also present in Cursor.executemany(), and the corresponding Connection.execute() and Connection.executemany() methods.)
Added Cursor.is_readonly, Cursor.is_explain, and Cursor.expanded_sql.
Updated processing named bindings so that types registered with collections.abc.Mapping (such as collections.UserDict) will also be treated as dictionaries. (APSW issue 373)