ngjaying

Support Alias for Stream/Table in Join clause

1

To allow self join

Provide a way to sink multiple rows (sink an array). For example, ```sql Select unnest(arr) From demo ``` This will produce multiple rows by unnest the array.

Support projection for json expressions

3

https://github.com/emqx/kuiper/blob/master/docs/en_US/sqls/json_expr.md#projections---not-support-yet

Signed-off-by: Jiyong Huang

**What would you like to be added/modified**: **Why is this needed**:

Provide a way to partition a stream by condition so that we can calculate independently. For example, if a stream contains data from all devices, we can partition by device...

Get the latest value of a column. If there is a value now return it, otherwise, return the last value

- Resource ~~ connection - Add test connection - Backward-compatibility - **Shared connection instance or not?**

Support decrypt in source and encrypt in sink. MQTT, file

Why do the stdev and var aggregate functions not ignore null values like sum, min, max, and avg ?

9

### Discussed in https://github.com/lf-edge/ekuiper/discussions/2589 Originally posted by **EscanorUt** January 26, 2024 Hello, I've noticed that while using eKuiper, the stdev and var aggregate functions seem to consider null values in...