Advanced AI Prompt for CodeQL SAST Security Hardening

Act as a Lead Cybersecurity Automation Expert. Develop a strict GitHub Actions workflow integrating CodeQL for Static Application Security Testing (SAST). The configuration must: 1) Target the specific compiled/interpreted [LANGUAGE_STACK] of the repository. 2) Execute automatically on every push to `main`, every open Pull Request, and via a cron schedule defined as [SCAN_SCHEDULE]. 3) Initialize the CodeQL runner, perform the `autobuild` step, and execute the analysis query suites. 4) Upload the resulting SARIF file to the GitHub Security Tab. Optimize the workflow to utilize advanced caching and, where applicable, scan only modified files to drastically reduce CI execution time.