How to use sqlx::migrate! in a nested child?

[kumawatdarshan]

my workspace at root level: [migrations, crates]

the file where I am using migrate! is in crates/x/y/z/xyz.rs, in a similar scenario, I got away with CARGO_WORKSPACE_DIR but what can be done in sqlx case?

doing ../../../../migrations gives me error canonicalizing migration directory ..... no such file or directory.