I’m using sqlx::query! to communicate with my PostgreSQL database from my Rust server. I often run into an issue where my queries stop working correctly after I run an ALTER TABLE. The macro doesn’t seem to recognize new columns, sometimes sees the wrong types, etc.

After spending a lot of time trying to fix this, it turns out the problem comes from Rust’s cache. Once I invalidate the cache, everything works again.

So my question is: Is it normal to have to invalidate the cache every time the database schema changes? Or is there a faster way to make Rust Analyzer and sqlx::query! “refresh” the database schema automatically?