[
https://issues.apache.org/jira/browse/CALCITE-7545?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18083009#comment-18083009
]
Yu Xu commented on CALCITE-7545:
--------------------------------
Thank you for raising this important point [~mbudiu] . You're right that OUT
and INOUT parameters introduce challenges to SQL's functional model.I will
limit the support for OUT and INOUT in the future.
> Support SQL User-Defined Functions (SQL UDF) with CREATE FUNCTION Syntax
> ------------------------------------------------------------------------
>
> Key: CALCITE-7545
> URL: https://issues.apache.org/jira/browse/CALCITE-7545
> Project: Calcite
> Issue Type: Improvement
> Components: core
> Affects Versions: 1.41.0
> Reporter: Yu Xu
> Assignee: Yu Xu
> Priority: Major
>
> Currently, Calcite only supports Java UDFs which require:
> - Writing and compiling Java code
> - Packaging JAR files
> - Using CREATE FUNCTION ... AS 'className' syntax
>
> This adds significant friction for simple functions. SQL UDFs address this
> by allowing:
> - Immediate function definition in SQL
> - No Java coding required
> - Parameter modes (IN/OUT/INOUT) support
> - Default parameter values
> - Full semantic validation
>
> This aligns Calcite with industry-standard databases like PostgreSQL/Spark...
> that support SQL UDFs natively.
> `CREATE FUNCTION` is also part of standard SQL; you can refer to the
> PostgreSQL documentation:
> https://www.postgresql.org/docs/current/sql-createfunction.html
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
