A few forward looking SQL dialects have started introducing lambda expressions to be used with functions operating on arrays

jOOQ is a Java library that provides a fluent API for building type-safe SQL queries and interacting with relational databases. With jOOQ, developers can write SQL queries in Java code, leveraging compile-time type checking and code generation to ensure correctness and maintainability. Developers can learn how to use jOOQ to simplify database interactions, reduce SQL boilerplate, and enhance productivity when working with SQL databases in Java applications.

JOOQ

Modern SQL dialects like ClickHouse, Databricks, DuckDB, Snowflake, and Trino are starting to incorporate lambda expressions, particularly for array manipulations. These languages now support useful functions such as array filtering, which can simplify operations on array data types. jOOQ allows for seamless integration of Java, Kotlin, and Scala lambda expressions into SQL queries. If a SQL dialect lacks native lambda support, similar functionality can be achieved with subqueries.

A few modern SQL dialects have started introducing lambda expressions