Author here. I agree with your remark but it simply isn't reality. Another issue is that while users may be aware of the core concepts, they are applied differently between applications (e.g. a relationship in Excel between tables is based on a VLOOKUP formula whereas in SQL it is a JOIN or carthesian product).
I do think data tools can educate users, just like a spreadsheet interface teaches its users about the concept of formulas and relationships between cells.