[Feature Request]: Support user creation in declarative migrations

[nmittler]

Using PostgreSQL 16 with the latest operator (0.5.0). Trying to create a AtlasSchema CR that includes sql with a CREATE ROLE command. The error I see both in the operator logs and the CRD status is that the role already exists. If I remove the command, my client fails (as expected) since the role does not exist. So it seems that the operator is stepping on itself somehow.

I reached out on discord and was told that create role isn’t supported yet in declarative migrations.

So I'm creating this issue to track the feature.