How to Write SQL Queries in WordPress

You almost never write raw SQL queries in WordPress because they have their ORM, right? It seems like every mature system like that has a mature and good ORM. Prisma generates the types, which is the best because you don't have to duplicate your types. So do you also share your client side types or do you make additional? Because sometimes the server side database stuff is not necessarily what should be put to the client as well. I think the most simple example is a password field shouldn't be on the client side.