Instead write a micro service on top of it that holds all the domain knowledge about how the data is structured in the storage layer? Stored procedures are not

Instead write a micro service on top of it that holds all the domain knowledge about how the data is structured in the storage layer? Stored procedures are not necessarily business logic, they can be an abstraction layer over the underlying structure, so yes, that can quite well make sense to place it in the DB.