What library let's me parse SQL with custom defined functions?

I want to parse an SQL with custom defined words like CUSTOM_FUNC

the custom_func() is defined by me somewhere that will do calculation on another sql query results.

SELECT FROM foobar CUSTOM_FUNC("SELECT FROM table");

It should have an actual SQL table where the sql will be affecting the rows.