chore(ci): merge in codeql.yml and mark as requirement for ci-success

chore(ci): merge in codeql.yml and mark as requirement for ci-success #269