Based on my personal experience, I have seen some raw SQL codes about 200 to 1000 lines in some production source codes, not readable at all, not easy to chang

Based on my personal experience, I have seen some raw SQL codes about 200 to 1000 lines in some production source codes, not readable at all, not easy to change, which is a terrible development experience. I guess if it is simple CRUD, it does not give too much problem, but it will definitely work in a complex case.