|Subject:||SQL::Parser fails to parse my valid example|
The attached self-contained program should return an object representing the parsed SQL. Instead it fails to parse the input, emitting the message Table 'jsr.date between brs' referenced in WHERE but not found in FROM list (alerts.board_revshare,rpt_view_job_search_net_revenue,jsr,brs)! at /tmp/sql-parse line 7 and returns undef. I don't understand why it thinks "jsr.date between brs" is a data source name. Is is possibly because it doesn't recognize the built-in function name "date_format"? But the manual does not explain how to teach the parser any more built-in function names. I'd think this would be part of the ->feature API, but if it is it's not mentioned.
Message body not shown because it is not plain text.