Few years ago I essentially went the same way though only up to a demo (because someone else got the contract) , but the target was to modify the ETL pipeline that before was implemented in hard coded T-SQL stored procedures and a Java app whose source code was evidently lost and recreated with disassembler.

The constructs in Blockly would have been used to generate the transform queries that turned input data into all kinds of summaries in snowflake schema