Working with Queries
Because the installer uses a relational database, there are functions for making Structured Query Language (SQL) queries to the database. The following procedure describes how to use SQL to query a database.
To query a database with SQL
A View object is the logical table created by applying a query to a set of tables. SQL queries must adhere to the SQL syntax provided by the installer. This SQL statement can contain parameter markers that are not specified until the View object runs.
You can also validate data with MsiViewModify by passing the appropriate flags. If MsiViewModify returns ERROR_INVALID_DATA from a validation request, the underlying data is corrupt.
For more information, see Examples of Database Queries Using SQL and Script.