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