Confused as to how compile time query checks work

[kartikynwa]

My main concern is whether it needs me to use sqlx's migrate feature. I see that it requires DATABASE_URL to be set, so I am guessing it talks to the database itself to validate the result of the query (using PREPARE based on other discussions). But I don't understand where exactly the database server knows the schema from. Thanks.

[CommanderStorm]

Well, your database needs to be migrated to have the shema you expect.

There are a number of solutions (the CLI, migrate-feature, external tooling such as Atlas..) how to do this, some better/worse for your workflow on a legal, organisational and personal level.