Optional parameters in procedures

This should also apply to `functions` 

This will be helpful for us too.

We have a procedure that will be extended with more parameters overtime.
But the issue that will arise with new parameters is that we need to add the extra parameter on all places in code where the procedure is called

@kenterweeme, Procedures will be possible to extend this way once this idea is implemented. Functions do always require all parameters to be filled, either with a value or with keyword DEFAULT.

From 2025.1, you will be able to specify default values for your Functions and Procedures (Subroutines) in your SQL Server, Oracle, and DB2 models. Note that the default values can only be literals, numbers, or NULL. Expressions or queries are not supported by any RDBMS.

The Program object will add the default value to the parameter definition for you:

To execute this procedure in your code, you can now do the following:

-- Default value will be used
execute generate_objects

-- Use a different value for the named parameter
execute generate_objects @generate_all_objects = 0 
-- Or index-based
execute generate_objects 0

For more information, follow the documentation of your RDBMS.