To retrieve all queries known to PowerDNS, run something like
# pdns_server --no-config --launch=gsqlite3 --config | fgrep '# gsqlite3-'
Then go visit the [Generic SQL Backends][docs] documentation and find your query documentation
(by removing the gsqlite3-
prefix from the pdns_server
output from above).