Manage SQL schemas through migrations

[daniel-mader]

Description

Having to set up the SQL database schemas by applying the init.sql script manually is becoming more of a pain point in multiple scenarios. We should use sqlx to manage the schema on application start, this also includes applying migrations automatically if necessary.

Motivation

Enhanced stability, better DX

Requirements

1. transform init.sql into sqlx commands
2. run sqlx commands on application start
3. define SQL migrations strategy

Open Questions

No response

Are you planning to contribute this in a PR?

Yes