Allow $ in identificators for SQL

[jasir]

In #90 there is a feature for full PL/SQL support.
We would like to address at least small bug.
In this query

   select value/1000 from  v$sesstat se,v$statname sn where se.STATISTIC# = sn.STATISTIC# and  sn.name =  'CPU used by this session' and se.SID=ss.SID

You can se v$abc identificators. They are valid, but they are marked as error by coderay. Is there anything we can do with this?

[korny]

Do you know whether $ is allowed in all SQL dialects?

[jasir]

It is allowed in postgreSQL and mySQL, just tried to create table with such identificators.

[korny]

Thanks! Can you share the code here? I would add it as a test case…

[benbasson]

@korny if I add tests for this will you consider merging the PR? Where would I go about adding tests?

[korny]

I added a test case in https://github.com/rubychan/coderay-scanner-tests/blob/master/sql/dollar-signs.in.sql.