SNOW-1763423: Ability to create new version of an app without permission to create schema in app package

[sfc-gh-rzukowski]

Description

In our setup we have detailed separation between users setting up new application package on provider account and users deploying new version.

We want to limit permissions required to call snow app version create to minimum. Ideally, MANAGE VERSIONS permission should be enough to create new version of the app package.

Currently, when executing snow app version create we have a query:

create schema if not exists <APP_PACKAGE>.<SCHEMA>

this schema will be used to create stage for artifacts.

Error is reported: SQL access control error: Insufficient privileges to operate on database

Both, schema and stage with artifacts already exists, we don't need to create one. We just want to reuse it.
But IF NOT EXISTS query fails because it needs permission to create schema.

Proposed solution:

1. Check if schema and stage exists in the snowcli
2. If schema/stage doesn't exists then attempt to create one and report error when permission is missing - otherwise continue working without permission to create schema / stage

Context

No response