Dynamic Pivot Reporting with Unpredictable Columns

Create a flexible PostgreSQL stored procedure that can dynamically generate pivot reports with an unknown number of columns at runtime. The procedure should accept a base table, pivot column, and value column as parameters, and return a fully dynamic crosstab result. Implement error handling for scenarios where no data matches the pivot criteria, and provide a method to handle potential SQL injection risks.