As pixxelkick already said, you most likely need some kind of mapping anyway between backend sql and frontend json. If you would have a language designed for interacting with sql databases it would probably suck for everything else.
In java with jooq and its generator it works pretty well, actually. You get the database types as java types and have rather safe queries. Type support breaks down for large and complicated queries, though.
We once had a very old house with a cellar that was not used and not built for living there in any way. So you had plain rock walls and it was pretty moist. I do not know why but there was a single basket of coal down there. So I have seen black coal but I have not touched it.
Crude oil I have seen too back in school. My teacher had a sample to be able to show it.