CODEWITHSUNDEEP
sqlfirebird
A R
A R

Reputation: 510

What is the name of the SQL variant used by FirebirdSQL?

I have been researching the names of the SQL versions used by different DBMSs.

So far I have:

Microsoft SQL -> Transact SQL
PostgrSQL -> PL/pgSQL
MySQL -> standard SQL (ANSI)
Oracle -> PL/SQL
Firebird -> ?

I haven't found anything about this. I read somewhere that it's PSQL, but I'm not sure if that is true, since the search results for it return many pages about postgres...

Upvotes: 1

Views: 331

Answers (1)

Mark Rotteveel
Mark Rotteveel

Reputation: 109015

Firebird simply has SQL, which is very close to standard SQL (probably closer than MySQL), it then discerns a number of different variants:

  • SQL, the basic variant (although some of the old InterBase documentation seems to use this to refer to ESQL as well)
  • ESQL (or Embedded SQL) which allows use of SQL directly in code (using a preprocessor), not used much these days
  • DSQL (or Dynamic SQL), this is what you usually use when executing queries against Firebird from a programming language
  • PSQL (or Procedural SQL) is the extension for stored procedures, stored functions, triggers and execute block

Upvotes: 2

Related Questions