all-things-risingwave
Is there a plan to support SQL UDF and LATERAL in the future?
The discussion thread involves a request for supporting SQL UDF for applying scalar functions on a per column basis and LATERAL for applying functions on a per row basis. The users are discussing the feasibility and potential challenges of implementing these features.
Jf
Jf p
Asked on Jul 17, 2023
- SQL UDF support for applying scalar functions on a per column basis is being considered for the roadmap.
- LATERAL support for applying functions on a per row basis is also under discussion, with considerations for potential challenges like nested loop joins and performance issues.
- Implementing LATERAL, which is part of the PostgreSQL standard, is feasible but requires careful consideration to prevent unintended consequences like OOM issues and performance degradation.
Jul 31, 2023Edited by