Need Python script to scan scripts/codebase files for list of Expressions

Looking for a script in Python that will scan a SQL Codebase (or any other code base) for list of Expressions and create an output file with –
a. count of occurrences of each expressions in the script
b. for each occurrence, provide line number in the codebase

There will be further enhancement needed based on the output of this requirement.