The main thing I can think of is that migrations would become much more painful, because your API is the entire capability surface of the relational database you're using -- no more and no less. Hyrum's Law suggests that your users will come to depend on every facet of it.

Then again, no doubt there are some cases where this is the best solution. But it's worth being cautious before adopting an approach like this.