# firebird

Published articles for firebird.

This is one page of public article previews, not the complete archive. Follow Next page to continue. Summaries are not the original full articles.

## Think About SQL MERGE in Terms of a RIGHT JOIN

DevFeed: [Think About SQL MERGE in Terms of a RIGHT JOIN](<https://devfeed.tech/articles/think-about-sql-merge-in-terms-of-a-right-join-28967.md>)

Original publisher: [Read original article](<https://blog.jooq.org/think-about-sql-merge-in-terms-of-a-right-join/>)

Author: lukaseder

Published: 2025-03-13T14:45:53Z

Content type: tutorial

Language: en

Sources: [jOOQ](<https://devfeed.tech/sources/jooq.md>)

Topics: [SQL](<https://devfeed.tech/topics/sql.md>), [etl](<https://devfeed.tech/topics/etl.md>), [rdbms](<https://devfeed.tech/topics/rdbms.md>)

Tags: [databricks](<https://devfeed.tech/tags/databricks.md>), [etl](<https://devfeed.tech/tags/etl.md>), [firebird](<https://devfeed.tech/tags/firebird.md>), [merge](<https://devfeed.tech/tags/merge.md>), [outer-join](<https://devfeed.tech/tags/outer-join.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [right-join](<https://devfeed.tech/tags/right-join.md>), [schema](<https://devfeed.tech/tags/schema.md>), [semantics](<https://devfeed.tech/tags/semantics.md>), [source](<https://devfeed.tech/tags/source.md>), [sql](<https://devfeed.tech/tags/sql.md>), [sql-server](<https://devfeed.tech/tags/sql-server.md>), [statement](<https://devfeed.tech/tags/statement.md>), [syntax](<https://devfeed.tech/tags/syntax.md>), [table](<https://devfeed.tech/tags/table.md>), [target-table](<https://devfeed.tech/tags/target-table.md>), [when-matched](<https://devfeed.tech/tags/when-matched.md>), [when-not-matched](<https://devfeed.tech/tags/when-not-matched.md>), [when-not-matched-by-source](<https://devfeed.tech/tags/when-not-matched-by-source.md>)

### AI overview

The article explains SQL MERGE by relating its target-and-source behavior to a RIGHT JOIN. It covers updating matching rows, inserting nonmatching rows, deletion behavior, and the restriction against duplicate matches.

### Source excerpt

RIGHT JOIN is an esoteric feature in the SQL language, and hardly ever seen in the real world, because almost every RIGHT JOIN can just be expressed as an equivalent LEFT JOIN. The following two statements are equivalent: It's not unreasonable to expect these two statements to produce the same execution plan on most RDBMS, ... Continue reading Think About SQL MERGE in Terms of a RIGHT JOIN ->

## The Many Ways to Return Data From SQL DML

DevFeed: [The Many Ways to Return Data From SQL DML](<https://devfeed.tech/articles/the-many-ways-to-return-data-from-sql-dml-28963.md>)

Original publisher: [Read original article](<https://blog.jooq.org/the-many-ways-to-return-data-from-sql-dml/>)

Author: lukaseder

Published: 2022-08-23T15:02:04Z

Content type: tutorial

Language: en

Sources: [jOOQ](<https://devfeed.tech/sources/jooq.md>)

Topics: [SQL](<https://devfeed.tech/topics/sql.md>), [Databases](<https://devfeed.tech/topics/databases.md>), [PostgreSQL](<https://devfeed.tech/topics/postgresql.md>), [Oracle Database](<https://devfeed.tech/topics/oracle-database.md>), [CockroachDB](<https://devfeed.tech/topics/cockroachdb.md>)

Tags: [article](<https://devfeed.tech/tags/article.md>), [cockroachdb](<https://devfeed.tech/tags/cockroachdb.md>), [data-change-delta-table](<https://devfeed.tech/tags/data-change-delta-table.md>), [database](<https://devfeed.tech/tags/database.md>), [firebird](<https://devfeed.tech/tags/firebird.md>), [generated-keys](<https://devfeed.tech/tags/generated-keys.md>), [how-to](<https://devfeed.tech/tags/how-to.md>), [jdbc](<https://devfeed.tech/tags/jdbc.md>), [jooq](<https://devfeed.tech/tags/jooq.md>), [mariadb](<https://devfeed.tech/tags/mariadb.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [return-generated-keys](<https://devfeed.tech/tags/return-generated-keys.md>), [returning](<https://devfeed.tech/tags/returning.md>), [sql](<https://devfeed.tech/tags/sql.md>)

### AI overview

This article explains ways to return data from SQL DML statements using jOOQ across multiple SQL dialects and directly through JDBC. It covers RETURNING-style syntax, Oracle PL/SQL emulation, PostgreSQL support, and the SQL standard's data-change-table reference approach.

### Source excerpt

Probably the hardest thing to standardise in SQL is RETURNING data from DML statements. In this article, we'll look at various ways of doing that with jOOQ, in many of jOOQ's supported dialects, and with JDBC directly. How to do it with jOOQ Assuming the usual table from the sakila database: jOOQ took syntactic inspiration ... Continue reading The Many Ways to Return Data From SQL DML ->