Parsed Query Trees
От | Kevin Neufeld |
---|---|
Тема | Parsed Query Trees |
Дата | |
Msg-id | 472F6509.10908@refractions.net обсуждение исходный текст |
Ответы |
Re: Parsed Query Trees
|
Список | pgsql-jdbc |
Does anyone know if a parsed query tree object is exposed in the jdbc API? I couldn't find any such thing, nor could I find it in the developers roadmap. My particular requirement is that I need to be able to parse / deconstruct an arbitrary SELECT query (which may be overly complicated) and add custom filters to the WHERE clause depending on what columns (optionally schema-qualified) and server datatypes are specified in the select clause. I'm currently use a sql parser that I wrote, but it seems silly to have to re-invent the wheel. I suppose I could use a 3rd party jar, like sql4j or Zsql, but these are rather old and simplistic and don't seem to do what I need them to do. Postgres is already parsing my sql queries - it would just be nice to have access to these parsed query trees so I can edit and then resend them to the database. Cheers, Kevin ------------- Kevin Neufeld Software Developer Refractions Research Inc. 300-1207 Douglas St. Victoria, B.C., V8W 2E7 Phone: (250) 383-3022 Email: kneufeld@refractions.net
В списке pgsql-jdbc по дате отправления: