TPSQLQuery

TPSQLQuery encapsulates a dataset with a result set that is based on an SQL statement.

Use TPSQLQuery to access one or more PostgreSQL tables in a database using SQL statements. TPSQLQuery component is useful because it can:

• Access more than one table at a time (called a "join" in SQL).
• Automatically access a subset of rows and columns in its underlying table(s), rather than always returning all rows and columns.