Create a view in SQL database using API

Hi team,

As we can't access the database to create a view in iMIS EMS (cloud version). Hence, I'm thinking is that possible to use API to create a view in SQL database?
What I'm trying to do is create a data source to filter the members that have more than 2 records in a muti-instance table. I have tried to use Business Object Designer but I'm not able to use having count function in the filter expression, hence need to find another way to filter the data.
Any idea/suggestion is much appreciated.

Thank you,
Vu