Update codeql workflow to use common codeql rules (#1093) #5189

Job	Run time
Component Tests	3m 52s
Build unsigned snapshot	6m 54s
Build signed snapshot	11m 39s
Build Grafana Dashboard Example	4m 10s
Lint	3m 37s
Performance Tests	7m 27s
Unit Tests	6m 28s
Integration Tests - Official OSS Images (bookworm, mainline, debian)	6m 30s
Integration Tests - Official OSS Images (bookworm, stable, debian)	6m 31s
Integration Tests - Official OSS Images (alpine, stable, alpine)	6m 25s
Integration Tests - Official OSS Images (alpine, mainline, alpine)	6m 24s
Integration Tests - Official Plus Images (alpine, 3.19, r31, alpine, /nginx-plus/agent)	6m 35s
Integration Tests - Official Plus Images (debian, bookworm, r31, debian, /nginx-plus/agent)	6m 34s
Integration Tests - Official Plus Images (debian, bookworm, r32, debian, /nginx-plus/agent)	6m 36s
Integration Tests (almalinux, 8)	8m 47s
Integration Tests (almalinux, 9)	7m 47s
Integration Tests (rockylinux, 9)	8m 1s
Integration Tests (amazonlinux, 2023)	8m 21s
Integration Tests (oraclelinux, 8)	9m 45s
Integration Tests - Official Plus Images (alpine, 3.20, r32, alpine, /nginx-plus/agent)	6m 34s
Integration Tests (ubuntu, 24.04)	6m 34s
Integration Tests (amazonlinux, 2)	9m 12s
Integration Tests (rockylinux, 8)	8m 39s
Integration Tests (oraclelinux, 9)	8m 51s
Integration Tests (alpine, 3.20)	6m 9s
Integration Tests (alpine, 3.18)	6m 12s
Integration Tests (debian, bullseye-slim)	6m 43s
Integration Tests (alpine, 3.21)	6m 15s
Integration Tests (alpine, 3.19)	6m 16s
Integration Tests (debian, bookworm-slim)	6m 37s
trigger-release-workflow	0s
	3h 30m 25s

Provide feedback