Ildus Kurbangaliev

Actually this case is more complex, `clickhouse` doesn't have direct equivalent of this operation. What do you expect to see on clickhouse side?

Missed these functions, could you add tests to check that they are working correctly and make a pull request?

Only way to push down these functions is to add them in postgres side so they could pass the parser. I have added bunch of other functions, but if you...

Sorry for the delay. There is no such thing as a roadmap here, basically we just add features that we need in our workflow. I would suggest to try out...

I will need some workflow to reproduce, could you provide sql script and table definitions?

Is this on binary or http protocol?

Sorry that the answer took so long. `http` for now supports only basic types for inserting, you can try `binary` protocol. I will add the support of more complex types...

Hi, unfortunately, there are no such options. The main purpose was to support aggregation queries with the limited amount of data in the result.

@iosifnicolae2 could you add sql tests for it (look for the comment from @Denchick)? That will show that the patch is working. Also please remove `.idea` files.

Facing same issue, using the firmware from 09.11.2023. The values showed as 'N/A' in zigbee2mqtt.