Release notes for 374

[martint]

No description provided.

[findepi]

PostgreSQL
* Improve performance of queries involving `OR` with simple comparisons and `LIKE` predicates
  by pushing predicate computation the underlying database. ({issue}`11086`)

#11086

[sopel39]

General
* Improve ``GROUP BY`` performance. ({issue}`11392`)

#11392

[mosabua]

Above added with minor rewording

[mosabua]

@sopel39 .. keep in mind that these snippets are markdown .. so single ` only ;-) cc @martint

[ebyhr]

# MongoDB
* Add support for [`CREATE SCHEMA`](/sql/create-schema) and [`DROP SCHEMA`](/sql/drop-schema). ({issue}`11409`)

#11409

[findepi]

Cassandra
* Fix incorrect query results for certain complex queries. ({issue}`11083`)

PostgreSQL
* Improve performance of aggregation queries with certain complex predicates by computing
  predicates and aggregations within PostgreSQL database. ({issue}`11083`)

#11083

[ebyhr]

# MongoDB
* Add support for [`COMMENT ON TABLE`](/sql/comment). ({issue}`11424`)

#11424

[findepi]

Delta Lake
* Fix query failures due to exhausted file system resources after `DELETE` or `UPDATE`. ({issue}`11418`)

#11418

[sopel39]

General
* Improve performance of `GROUP BY` with a large number of groups. ({issue}`11011`)

#11011

[sopel39]

General
* Produce better query plans by improving cost-based-optimizer estimates in the presence of correlated columns. ({issue}`11324`)

#11324

[hashhar]

# CLI
* Add support for Vim and Emacs editing modes which can be chosen via the `--editing-mode` command line argument. ({issue}`3377`)

#3377 #3602

[mosabua]

All above added.

[ebyhr]

# Cassandra
* Add support for [TRUNCATE TABLE](/sql/truncate). ({issue}`11425`)

#11425

[mosabua]

Above added

[hashhar]

## SingleStore (MemSQL) connector
* The connector now uses the official [Single Store JDBC Driver](https://docs.singlestore.com/managed-service/en/developer-resources/connect-with-application-development-tools/connect-with-java-jdbc/the-singlestore-jdbc-driver.html).
  As a result, `connection-url` in catalog configuration files needs to be updated from `jdbc:mariadb:...`
  to `jdbc:singlestore:...`. ({issue}`10669`)

#10669 #11301

[hashhar]

# PostgreSQL
* Fix possible connection leak when connecting to PostgreSQL failed. ({issue}`11449`)

[mosabua]

Both added...

[ebyhr]

# General
* Fix `trim`, `ltrim` and `rtim` function results when the argument is `char` type. 
  Previously, it returned padded results as `char` type. It returns `varchar` type without padding now. ({issue}`11440`)

#11440

[ebyhr]

# SingleStore (MemSQL)
* Deprecate `memsql` as the connector name. We recommend using `singlestore` in the `connector.name` configuration property. ({issue}`11459`)

#11459

[ebyhr]

# MongoDB
* Add support for [`COMMENT ON COLUMN`](/sql/comment). ({issue}`11457`)

#11457

[findepi]

JDBC driver
* Add support for `DatabaseMetaData.getImportedKeys`. ({issue}`8708`)

#8708 #11472

[ebyhr]

# MongoDB
* Support storing a comment when adding new columns. ({issue}`11487`)

#11487

[findepi]

Iceberg
* Add support for using Glue metastore as Iceberg catalog. ({issue}`10845`)

#10845

[ebyhr]

# ClickHouse
* Add support for `uint8`, `uint16`, `uint32` and `uint64` types. ({issue}`11490`)

#11490