Describe the bug
Sometimes alias time does not work

To Reproduce

create table tst (
timestamp timestamp
)

select timestamp time from tst

Expected behavior
Result column name is timestamp but should be time

Screenshots

Environment (please complete the following information):

• Version: 6.0.2

Additional context
This is the workaround sy

Use case:
Right now one can only use date_trunc() to easily define time buckets. date_trunc() only supports predefine time intervals like 1 minute, 1 hour, etc. . In time-series use cases it is often necessary to define different time bucket sizes like e.g. '5 minutes' or '20 minutes'

a workaround for this is the - error prone - integer division on the timestamp e.g.

S

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.

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