--- title: "A few modern SQL dialects have started introducing lambda expressions" url: https://daily.dev/posts/a-few-modern-sql-dialects-have-started-introducing-lambda-expressions-s7xpcfvfr source_url: https://blog.jooq.org/when-sql-meets-lambda-expressions/ type: article source: "JOOQ" published: 2025-03-27T13:23:43.323Z updated: 2025-03-27T13:24:12.948Z tags: ["sql", "databricks", "clickhouse", "duckdb"] reading_time: 2 upvotes: 4 comments: 0 language: en --- > ## Documentation Index > Fetch the complete documentation index at: https://daily.dev/llms.txt > Use this file to discover all available pages before exploring further. # A few modern SQL dialects have started introducing lambda expressions **[JOOQ](https://daily.dev/sources/jooq)** · 2 min read · 4 upvotes · 0 comments ## Summary 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. ## Full article daily.dev links to this article rather than hosting it. Read it at the original source: ## Similar posts on daily.dev - [Don’t just attend KubeCon \+ CloudNativeCon, Merge Forward your experience\!](https://daily.dev/posts/don-t-just-attend-kubecon-cloudnativecon-merge-forward-your-experience--l0rpp73x8) · CNCF · 0 upvotes · 0 comments - [Announcing H2 2026 KCDs](https://daily.dev/posts/announcing-h2-2026-kcds-m96goajm1) · CNCF · 1 upvotes · 0 comments - [Two months of Open Community Groups](https://daily.dev/posts/two-months-of-open-community-groups-asf52zhbs) · CNCF · 0 upvotes · 0 comments --- Tags: [#sql](https://daily.dev/tags/sql), [#databricks](https://daily.dev/tags/databricks), [#clickhouse](https://daily.dev/tags/clickhouse), [#duckdb](https://daily.dev/tags/duckdb) [View this post on daily.dev](https://daily.dev/posts/a-few-modern-sql-dialects-have-started-introducing-lambda-expressions-s7xpcfvfr)