filter clause

BigQueryDb2 (LUW)MariaDBMySQLOracle DBPostgreSQLSQL ServerSQLite200520072009201120132015201720192021✓ 3.30.0+b⚠ 3.25.0 - 3.29.0b⊘ 3.5.7 - 3.23.1⊘ 2008R2 - 2019✓ 9.4+⊘ 8.3 - 9.3⊘ 11gR1 - 21c⊘ 5.0 - 8.0.30a⊘ 5.1 - 10.9.2⊘ 9.7 - 11.5.7⊘ 2.0
  1. The filter_plugin extension (3rd party) rewrites filter to case using regular expressions
  2. Only for window functions (over)