SQL has been enormously successful as a database interface language, but its lack of consistency is well known. SQL is not an orthogonal lanaguage. Capabilities available in one context are not in others.
Common queries require inconvenient and poor performing work-arounds to accomplish.
FirstSQL fully supports ANSI syntax and provides ODBC extensions. In addition, FirstSQL provides innovative extensions to standard SQL that greatly increase the power of SQL in manipulating data. Compare your database's capabilities with those described in this section. FirstSQL allows a subquery producing a single value to be used any place a scalar value can.