Why doesn RDM Embedded support all of the SQL API?
Embedded SQL was originally designed from the ground up to run in restricted environments. In these environments, excess code in a database engine takes away from valuable space needed by applications. Our selection of ODBC API functions and SQL language was based on what was essential for programming embedded applications. Even in larger environments, a complete SQL is not desirable. Embedded databases are typically controlled by a single application where the concept of users with various levels of access rights on views of the database is irrelevant. By omitting views and access rights functionality, Embedded SQL is optimized for the embedded deployment.
