If we could have one and only one of our objects, and couldn't have any of the others, then this would be it without any hesitation. For SQL database work it's absolutely, positively invaluable.

What it does, simply, is parse the SQL property of a TQuery component's property into SELECTFROM, WHERE and ORDERBY (including HAVING and GROUPBY) clauses, accessible as properties.

It can also reassemble a TQuery's SQL property with a different WHERE clause, as for example from our Find object.

When used in conjunction with the Crystal Report Editor object, it instantiates an encapsulated, non-visible TCRPE object, and parses the Crystal Report's SQL property into SELECTFROM, WHERE and ORDERBY (including HAVING and GROUPBY) clauses, accessible as properties of the object. Also used to send a WHERE clause, combined with the Crystal Report's original SELECTFROM and ORDERBY clauses, to either a preview window or to the default printer.

This is a non-visible object, usually managed by the Application Object, and is used in more places than you could possibly imagine.