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)

Freedomotic supports more than 20 languages using Transifex.
We are searching contributors for new languages or existing translations.

Solution 1 (recommanded in particular for a new language)

• Join our team on Transifex https://www.transifex.com/freedomotic/freedomotic-open-source-buildi/
• Complete the translation
• Download the file .properties and submit a PR

Solution 2

• Wor

Problem or use case

The client is currently only logging errors and warnings. For debugging purposes and during application development, it would be very useful to also have logs detailing the message flow.

Preferred solution or suggestions

TRACE level logging for incoming and outgoing MQTT control packet types, e.g., PUBLISH, SUBSCRIBE, PUBACK, SUBACK.