You can perform various operations on your collection using an API Keys.
@velo/wix-data-sql-backend
Please install the Velo Packages '@velo/wix-data-sql-backend', and copy the code below to expose a function called post_sql as an HTTP Functions function.
After that, you can set the https://your.domain.com/_functions/sql as SQL Endpoint. This endpoint will be used to execute SQL queries.
*Please be cautious when using this, as it may lower the security level.