title: Is there a way to parser a SQL query to pull out the column names and table names?
body: <p>I have 150+ SQL queries in separate text files that I need to analyze (just the actual SQL code, not the data results) in order to identify all column names and table names used. Preferably with the number of times each column and table makes an appearance. Writing a brand new SQL parsing program is trickier than is seems, with nested SELECT statements and the like. </p>
  
  <p>There has to be a program, or code out there that does this (or something close to this), but I have not found it.</p>