I know plenty of people who only use sql. There is now a role called analytics engineer that primarily sql and often with transformation tools like dbt.

I personally haven’t met a lot of software devs who would call their data modeling capabilities ‘good enough’. It is a different way of thinking to go from building 3rd form normalized tables to denormalizing everything. Plus if a company is merging data from many systems, it makes it more complicated for the software developer.