The primary reason organizations are designing and deploying APIs is to make data accessible outside the enterprise from database sources. Currently, many APIs mirror the structure of database tables, which is not ideal for effective API design.
While it often happens that database tables dictate API design, the focus should be on creating a more thoughtful approach. The main goal for many is simply to provide secure access to data over the web. APIs serve this purpose well, with HTTP offering a straightforward and cost-effective way to extend access to your database for the intended users.
This is just the starting point, though. It’s important to evolve your design beyond mere database representation. Moving forward, aim for a more sophisticated approach that transcends traditional methods like open database connections and Java database access.