Use `module_pathname`instead of `@HAF_GIT_REVISION_SHA@` in sql
Instead of using @HAF_GIT_REVISION_SHA@
we can use MODULE_PATHNAME
in our sql files.
This would remove the need to use SQL "PROXY" file, also it would be compatible with the standard.
We can achieve that by doing something similar to this: https://gitlab.com/mtyszczak/mpe/-/commit/055209479002d301ad78fc61352a9ad2bb93bcc2