Object Oriented Wrapper classes to SQL statements
Date: 11 Dec 2001 00:06:47 -0800
Message-ID: <411c2c2f.0112110006.77a70687_at_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 - 09:06:47 CET