MS Fabric Data Flow Gen2. Can I write to an on-premise SQL Server?

I will probably get banned for this, but in my opinion, Dataflows Gen2 for Fabric is DOA. While a great idea in principle, DFG2 was either rushed to market or not sufficiently thought out. Consider the fact that users have been complaining from Day 1 that DFG2 objects cannot communicate with Pipeline objects. Microsoft said they would fix this in the H1 2024. Well, here we are in August and nothing yet. With all this said, Notebooks are the only way to really accomplish anything in Pipelines. Will that ever change? Who knows?