Is the same problem with Excel/Acces and similar.
They have a good tool, but the language them use for glue things are not a match for the task the tool do.
For example, Excel. VBA have impedance mismatch with the way excel visualy work. If, isntead, it have a more array-based language and bit more functional, then the way you use excel will be the way you code for it.
That is in fact the power FoxPro have. You can make forms with tables, because, forms ARE tables. The syntax and basic operations work fine with the relational storage. You can SELECT INTO ARRAY and stuff like that, or just not use SQL.