insert … on conflict …

BigQueryDb2 (LUW)MariaDBMySQLOracle DBPostgreSQLSQL ServerSQLite200520072009201120132015201720192021⚠ 3.25.0 - 3.40.0b⊘ 3.5.7 - 3.23.1⊘ 2008R2 - 2022✓ 9.5+⊘ 8.3 - 9.4⊘ 11gR1 - 21ca⊘ 5.0 - 8.0.31⊘ 5.1 - 10.10⊘ 9.7 - 11.5.7⊘ 2.0
  1. Also log errors for insert, update, delete, and merge (“DML error logging”)
  2. On conflict must not immediately follow the from clause of a query. Add where true if needed