I remember being taught Model-driven development using Eclipse as part of the software engineering study back in the early 2000’s. Even as a student it was painfully obvious that you’d spend an awful lot of time trying to work around annoying limitations in whatever tool was used, rather than just writing the code yourself. The parallel to vibe-coding seems rather obvious.
After working on a few different projects, I’ve always ended up using ORM for normal operations and Stored Procedures for the complex stuff.
If using MS products, the Database project type in Visual Studio even adds some basic static checking to SQL to help you out a little.
Had the pleasure of taking over maintenance of a moderately complex application with a data access layer based entirely on Stored Procedures once - that was fun…