Background - In on-prem pega we have 3 stored procedure which holds 90 queries each performs diff operation like delete, insert etc to 90 different tables based on business user preference [using connect sql we call stored procedure in oracle]

ISSUE- we are in process to migrate to pega cloud 8.8 and in mitigation plan, we see pega recommends to convert stored procedure to obj methods/report definition as it wont support custom queries/stored procedure

But considering our design and tables involved we like to keep the stored procedure in postgresql too

Question - 

1. Can we add stored procedure in pega cloud DB postgresql

2. what are the other options to implement?

3. can we create custom schema in postgresql (pega cloud DB)