The reason people don't know about prepared statements is because typical database infra is dumb and makes it hard to take advantage of them in a real non-toy codebase.

That's why things like asyncpg and edgedb use them under the hood to make users rip benefits automatically. 💰