A typical web tech stack is a frontend , backend and db
My prediction is the future for many ( not all) apps will be an LLM dynamically built frontend, using something like this https://tambo.co/blog/posts/introducing-tambo-generative-ui or MCP UI
Plus a DB that has strict permissions (think postgres RLS) and validation (check constraints etc)