[Python-checkins] [3.11] gh-96165: Clarify omitting the FROM clause in SQLite queries (GH-106513) (#106646)

[erlend-aasland]

https://github.com/python/cpython/commit/6d8662381d73982f53d3cc71bf435aa82def8eab
commit: 6d8662381d73982f53d3cc71bf435aa82def8eab
branch: 3.11
author: Miss Islington (bot) <31488909+miss-islington at users.noreply.github.com>
committer: erlend-aasland <erlend.aasland at protonmail.com>
date: 2023-07-11T22:30:52+02:00
summary:

[3.11] gh-96165: Clarify omitting the FROM clause in SQLite queries (GH-106513) (#106646)

(cherry picked from commit fc7ff1af457e27b7d9752600b3436641be90f598)

Co-authored-by: Mariusz Felisiak <felisiak.mariusz at gmail.com>

files:
M Doc/library/sqlite3.rst

diff --git a/Doc/library/sqlite3.rst b/Doc/library/sqlite3.rst
index c99c01b0e5c79..a50be741ce8bc 100644
--- a/Doc/library/sqlite3.rst
+++ b/Doc/library/sqlite3.rst
@@ -2311,6 +2311,13 @@ Queries now return :class:`!Row` objects:
    >>> row["RADIUS"]  # Column names are case-insensitive.
    6378
 
+.. note::
+
+    The ``FROM`` clause can be omitted in the ``SELECT`` statement, as in the
+    above example. In such cases, SQLite returns a single row with columns
+    defined by expressions, e.g. literals, with the given aliases
+    ``expr AS alias``.
+
 You can create a custom :attr:`~Cursor.row_factory`
 that returns each row as a :class:`dict`, with column names mapped to values: