What are the syntax differences between MySQL SQL queries and Firebird?

Question

MySQL

So, in fact, the essence of the question is this: there are three different FireBird databases, one PostgreSQL database, and a small MySQL database.
Phone traffic is stored in FB, Internet traffic is stored in Postges, and CRM connects it with a MySQL database. Yes, recently, data loading into CRM from Postgres was implemented, since I know the differences between MySQL and PostgreSQL, I created a class for converting muscle queries into postgres, since I know muscle queries for a very long time, but they are simpler, dearer. But now there is a need to also fasten FB. Faced with the fact that it does not digest back quotes at all, a kind of LIMIT and the structure of procedures and triggers in general are fundamentally different.
Are there any manuals, resources or just infa where you can see all these differences, or write a short list of them.
Thank you in advance for your response!
PS: they didn't ban me on google, the only thing I found is https://scott.yang.id.au/2004/01/limit-in-select-s... , but on off. The site has only language documentation in Russian, even, 516 pages, but I need exactly the
PPS differences: I found it on off. PDF site: Migration from MS-SQL to Firebird

Answer 1

I don't remember exactly, I worked with FB for a long time... But, of all the SQL databases I know, MySQL is the only database that invented "Own SQL with blackjack and... its own LIMIT format".
Here, I found a quote regarding FireBird 1.5:
Following the above, and the fact that Postgres also implements most of these standards, queries should work in both FireBird and Postgres, with little to no change. Also, as far as I remember, in FireBird (at least it was in versions 1.5 and 2.x), just like in Postgres, "sequences" are used , instead of MySQL's AUTOINCREMENT'a.
Summing up, I want to say that you need to look not for how FireBird's syntax differs from MySQL's, but for how MySQL's-SQL differs from SQL standards.

a kind of LIMIT

-- LIMIT/OFFSET? If you are talking about him, then this is not a "peculiar" LIMIT, this is LIMIT in accordance with the standards, LIMIT separated by commas is an invention of the MySQL authors.