Fixes cockroachdb#114775 Release note (sql change): PL/pgSQL now supports nested blocks, with the following limitations for now: variable shadowing is disallowed, and exception handlers cannot be used ...

The nested function in SQL and PPL maps to the nested query DSL in the OpenSearch query engine. A nested query is used to search nested object field types in an index.

This paper describes a SQL Narrator designed using a Context-free Grammar that reads and generates narrations for queries using predefined templates. The SQL Narrator is able to narrate nested queries ...

This paper presents a technique for weaving temporal semantics into an SQL query. We assume that a query writer programs a query and then annotates the query with some temporal semantics, such as ...