My approach is to use code generation tool to handle the typing and API (server side routing and client side SDK) in one-step.

DB side is not handled by the tool because that's a blackbox the client don't need to know.