Sponsor of the Day:
Jerkmate
https://www.dremio.com/blog/table-driven-access-policies-using-subqueries/
Table-Driven Access Policies Using Subqueries | Dremio
Aug 28, 2025 - Implement table-driven access policies using subqueries. Explore Dremio's latest blog for insights into efficient data access control strategies.
access policiestabledrivenusingsubqueries
https://duckdb.org/docs/lts/sql/expressions/subqueries
Subqueries – DuckDB
Subqueries are parenthesized query expressions that appear as part of a larger, outer query. Subqueries are usually based on SELECT ... FROM, but in DuckDB...
subqueriesduckdb
https://mariadb.com/docs/server/reference/sql-statements/data-manipulation/selecting-data/subqueries/subqueries-in-a-from-clause-derived-tables
Subqueries in a FROM Clause (Derived Tables) | Server | MariaDB Documentation
Use a subquery as a temporary table. Derived tables allow you to select from the result set of another query within the FROM clause.
tables server mariadbsubqueriesclausederiveddocumentation
https://jira.mariadb.org/browse/MDEV-21102
[MDEV-21102] Server crashes in JOIN_CACHE::write_record_data upon EXPLAIN with subqueries and...
server crasheswrite recordmdevjoincache
https://www.jooq.org/doc/3.21/manual/sql-building/dsl-context/custom-settings/settings-scalar-subqueries/
Settings: scalar subqueries for stored functions
This setting is useful mostly for the Oracle database, which implements a feature called scalar subquery caching, which is a good tool to avoid the expensive...
stored functionssettingsscalarsubqueries