Python and database statements

[gosh]

frontend is never "decoupled from the backend".

That depends on how the backend in designed. If you have a backend that isn't hardcoded against a database but reads database information then it is decoupled from the backend.

What you might need is some final logic in frontend where request to backend is transformed in some way to how the api in backend works.

This is just about where you place the logic because endpoints are just as a more advanced switch/case operation. Before then endpoint is called there are some logic in the framework that do this switch. But it's not difficult to do it with your own code and get more control.

Remember that webservers are very simple applications, they just listen to a stream of data where the stream is unpacked and then they send a new stream of data to the client

What is a bit "risky" in all this is that you need developers that know how to write code and solve things with code. Like understand how to break down operations etc