I may be making this up but pretty sure cfqueryparam lets you skip the

CF_SQL_

prefix doesn't it these days? Not mentioned in the docs https://helpx.adobe.com/uk/coldfusion/cfml-reference/coldfusion-tags/tags-p-q/cfqueryparam.html

I have the same memory too but I've ever actually tested it or remember when it came into being. CFDocs lists them - https://cfdocs.org/cfqueryparam

Yes; we're using CF2018 and 2021 and I skip the prefix.

According to https://cfdocs.org/cfqueryparam, you can omit the prefix as of CF11