Unfortunately, we don't support placing custom sql queries in the assay/<name>/queries directory of a file-based module. I agree it would make writing the assay portable and much easier. For now, only the assay metadata overrides are supported for the built-in assay tables.