Sometimes it is needed to store compressed data in the DB. Unfortunately not all the DBs have built-in compression and FUSE compressed FSes are not available for every OS. So it may make sense to store compressed binary blobs in the DB.

Unfortunately when one sees them in DBeaver he sees them compressed, but often they are needed uncompressed. So it'd be nice to have a feature to decompress the

Running : CLI v0.11.0, Server v0.11.0
(pulled from confluentinc/ksqldb-server:0.11.0)

Creating a stream with a field named "size" results in the following error :
extraneous input 'size' expecting {'EMIT'

It seems like size is considered a reserved keyword.
Creating the stream with CREATE STREAM trades ( "size" DOUBLE ) works.

Looks similar to https://github.com/confluentinc/ksql/issu

Use case:

Have better compatibility with PostgreSQL tools

Feature description:

PostgreSQL supports various Data Type Formatting Functions

CrateDB has date_format and format as alternative, but for improved tooling support it would be good to have the PostgreSQL variants:

• `to_char(timestamp, text

QuestDB implements regex string match with the operators ~= and !~. However, LIKE is not implemented.

Describe the solution you'd like
Implement LIKE such that
column LIKE pattern becomes ~=(column, pattern)
NOT column LIKE pattern becomes !~(column, pattern)

SELECT custkey, sum(totalprice)
FROM orders
GROUP BY custkey
ORDER BY 2 DESC

EXPLAIN

                                      Query Plan
---------------------------------------------------------------------------------------
 Fragment 0 [SINGLE]
     Output layout: [custkey, sum]
     Output partitioning: SINGLE []
     Stage Execution Strategy: UNGROUPED_EXECUTION

Currently, the JDBC string containing the host name and port is hardcoded. For example, consider the connection string for MySQL:

https://github.com/sqlancer/sqlancer/blob/e62224edcb43fe421dc87601f75090739e34e595/src/sqlancer/mysql/MySQLProvider.java#L248

It would be desirable to make this configurable. We could provide an option to set the JDBC string for each DBMS. For example, for MySQL,