title: Extracting order type from sql parser
body: <p>using  <code>global sql parser (gsp)</code> for extracting column and sorting type from order sql query and extract and or from where condition</p>
  <pre><code>SELECT employee_id, dept, name, age, salary
  FROM employee_info
  WHERE dept = 'Sales' and ID=1
  ORDER BY salary, age DESC,ID;
  </code></pre>
  <p>I can extracting column name but can extract order type</p>
  <blockquote>
  <p>1- how can extract order type?</p>
  <p>2- how can extract and , or from where sql?</p>
  </blockquote>