Documentation Source Text

    [DBSTAT virtual table].
<li>Add the [SQLITE_OPEN_NOFOLLOW] option to [sqlite3_open_v2()] that
    prevents SQLite from opening symbolic links.
<li>Added the "#-N" array notation for [JSON function path arguments].
<li>Added the [SQLITE_DBCONFIG_TRUSTED_SCHEMA] connection setting which is
    also controllable via the new [trusted_schema pragma] and at compile-time
    using the [-DSQLITE_TRUSTED_SCHEMA] compile-time option.
<li>Added APIs [sqlite3_filename_database()], [sqlite3_filename_journal()], and
    [sqlite3_filename_wal()] which are useful for specialized extensions.
<li>Add the [sqlite3_uri_key()] interface.
<li>Upgraded the [sqlite3_uri_parameter()] function so that it works with the
    rollback journal or WAL filename in addition to the database filename.
<li>Provide the ability to tag [application-defined SQL functions] with
    new properties [SQLITE_INNOCUOUS] or [SQLITE_DIRECTONLY].
<li>Add new verbs to [sqlite3_vtab_config()] so that the [xConnect] method
    of virtual tables can declare the virtual table as
    [SQLITE_VTAB_INNOCUOUS] or [SQLITE_VTAB_DIRECTONLY].
<li>Faster response to [sqlite3_interrupt()].
<li>Added the [https://sqlite.org/src/file/ext/misc/uuid.c|uuid.c] extension module

<title>Generated Columns</title>
<tcl>
hd_keywords {generated columns} {computed columns} {generated column}
</tcl>
<table_of_contents>

<h1>Introduction</h1>

<p>Generated columns (also sometimes called "computed columns")
are columns of a table whose values are a function of other columns
in the same row.
Generated columns can be read, but their values can not be directly

}

Pragma hard_heap_limit {
    <p><b>PRAGMA hard_heap_limit<br>
          PRAGMA hard_heap_limit=</b><i>N</i></p>

    <p>^This pragma invokes the [sqlite3_hard_heap_limit64()] interface with
    the argument N, if N is specified and N is a positive integer that
    is less than the current hard heap limit.
    ^The hard_heap_limit pragma always returns the same integer
    that would be returned by the [sqlite3_hard_heap_limit64](-1) C-language
    function.  ^That is to say, it always returns the value of the hard
    heap limit that is set after any changes imposed by this PRAGMA.
    </p>