Calculation of the quantity and value of stock balances in real time using FIFO?

Question

MySQL

We have a list of transactions:
sql.developerworkshop.net/fifo.zip (example from the article at the link below, 38Mb)
Found a solution using Transact-SQL
https://ask.sqlservercentral.com/questions/1961/th...
Is it possible similar implementation in mysql? Which database is best suited for working with financial data? Does Transact-SQL only exist for Microsoft SQL Server?

Answer 1

Does Transact-SQL only exist for Microsoft SQL Server?

yes, it's a microsoft dialect.
in the example, at first glance, there is nothing that is not implemented on MySQL. Or on Postgre (which is more likely).
MSSQL Express is free and fully supports T-SQL. If you play around, then it's enough. If something serious - you can buy.