Changelog
Improvements for prepared statements
06.06.2025
We've improved support for prepared statements in Materialize. While we generally recommend using indexed views and/or materialized views over prepared statements, various external tools rely on prepared statements. As such, we've made the following improvements for better integration:
- Expanded support: Support prepared statement parameters in the
OFFSETandRETURNINGclauses. - Improved type handling: Arguments to EXECUTE statements are automatically assignment-cast as needed.
- Better error reporting: Return
42P02 undefined_parameter SQLSTATEwhen appropriate.