Option to generate per-crate sqlx in —workspace mode

[macalinao]

I have found these related issues/pull requests

N/A

Description

If using Nix, the global .sqlx directory in workspace mode creates a large artifact set that causes rebuilds for each crate whenever a query in any crate changes.

Using the per-crate mode is slow; workspace mode should have the option to generate .sqlx files relative to the crate root.

Prefered solution

Generate the .sqlx files relative to each crate with a flag.

Is this a breaking change? Why or why not?

Not breaking. Should be behind a flag.