Object Oriented Wrapper classes to SQL statements

From: Rachel <rebner_at_checkpoint.com>
Date: 11 Dec 2001 00:06:47 -0800
Message-ID: <411c2c2f.0112110006.77a70687@posting.google.com>

Hello all!

In our project, we allow the user to create queries on a database. The user is not assumed to know SQL, and has an interface that presents column names and lets him specify conditions. Currently, we work with a single table, but may extend it to multiple tables in the future.

My question is:
Is it possible, and is it wise, to write a set of C++ classes to encapsulate the structure of an SQL statement? That is, can you create a set of objects to model an SQL statement? On one hand, I would like to keep this model as general as possible (i.e parallels to SQL general syntax). On the other hand, if this may turn to be extrmemely complicated, I can use the assumption of a single table.

If any of you know of existing packages (open source or commercial) that have such a model - please let me know.

Thanks! Received on Tue Dec 11 2001 - 02:06:47 CST