Was your prompt just "I want a simple crud webapp" and that's the extent of it? There's absolutely no way you included the words "python", "flask", or "sqlite" and it still went with a Microsoft stack.

Dotnet minimal APIs plus mssql is fine for simple crud apps… I would do Postgres, but that’s me.

Swapping mssql to SQLite would also work perfectly

You could have just added “flask SQLite stack” to whatever prompt you added. Just those three words, randomly somewhere in your prompt.

> insane techstack involving C#, Razor Pages, MSSQL

Is a very sane tech stack, you're just biased against Microsoft.

Half the world's enterprise apps run on that combination, or a minor variation of it.

Like Java it is full featured ("batteries included") but unlike Java it is relatively terse and actually pleasant to work with.

Oh, and unlike Python, it is very fast, within spitting distance of compiled Rust and C++ web apps.