Support for Subqueries

[vahidhashemian]

This may be covered under full implementation of stream-table and table-table join, but just in case, supporting subqueries would be a valuable addition to KSQL.

Simplified example: For the stream cart_action_stream (session, customer, product, cart_action) finding abandoned cart items of each customer can be done with this simplified query:

select customer, product from cart_action_stream
where cart_action='add'
and session in (select session from expired_sessions_table)
and (session, product, 'purchase') not in (select session, product, cart_action from cart_action_stream where)

where expired_sessions_table(session) is built via a separate query.

[frossi85]

Hi guys, I was trying to implement a feature with a subquery then I find that was not possible to do it. Is is in the Docs because I did not find it? If not, maybe is a good idea to include it.

Also do you have some estimate or roadmap so I can see when this kind of issues are gonna be solved?

[ReasonDuan]

Has any update? This is a very important feature.

[j3works]

Happy New Year, everyone! Is the subquery capability being planned for a future release of ksqlDB within the next 12 months?

[Mall0c]

Anything new about subqueries? This would be a great improvement of ksql :-)

[SebaLopez94]

Any news?

[nmatare]

Yes please. :)

[ofelix03]

I guess I will follow the trend as I found myself needing subquery feature in KSQLDB for my current project. Any update?

[sh3b]

Same here, any update on this?

[JasonDWilson]

+1