I am uneasy about databases being used in general how they are today. Nobody writes SQL to read and write records directly. it's all pumped through business log

I am uneasy about databases being used in general how they are today. Nobody writes SQL to read and write records directly. it's all pumped through business logic. Then you write a stored procedure to update x-on-y and the business logic breaks, in a scenario that is impossible for the business logic to produce. additionally the logic is very far away from the data in many cases, obfuscated through layers of data modelling. If there was a way to bring these closer, that would be nice.