def METHOD_NAME(self, directory: pathlib.Path) -> List[pathlib.Path]:
    """Locates the files in a directory, that are supported for execution.
    Files supported for execution are: .sql and .py
    Other files in the directory are ignored.
    :return: List of files from the directory that supported for execution, sorted alphabetically by name.
    :rtype: :class:`.list`
    """
    script_files = [
        x
        for x in directory.iterdir()
        if (x.name.lower().endswith(".sql") or x.name.lower().endswith(".py"))
    ]
    script_files.sort(key=lambda x: x.name)
    log.debug(f"Script files of {directory} are {script_files}")
    return script_files