Re: Loadable Oracle Personality: WAS "LinuxTag wrapup"

On Wed, 2004-07-07 at 02:04, Justin Clift wrote:
> Simon Riggs wrote:
> <snip>
> > External tool is one thing, but the loadable personality seems like a
> > very good idea and worth discussing further.
> 
> Would an interesting, and maybe slightly different way of viewing a 
> "loadable personality," be as a set of "rules" that can be applied to 
> parser input before the parser actually gets it... and massages input 
> SQL into something for the parser to understand.
> 
> I'm hugely generalising here of course, but you know how we have a 
> PostgreSQL "Rules" system that rewrites queries before handing them to 
> the query planner... well, would it be possible/practical to potentially 
> have a "Rules" system that rewrites incoming SQL before it gets given to 
> the normal parser.
> 
> Might get complicated though... we'd need a pre-parser or something.
> 
> However, having a generalised system for doing this may make it far 
> easier to provide "personalities".  i.e. load a set of Oracle 8i rules, 
> load a set of Oracle 9i rules, load a set of DB2 x, rules, etc.
> 
> :)
> 

...Something to return to later, when this release is done.

Best regards, Simon