I am working on a conlang and wondering if there is any different way to deal with these "locative" words than either prepositions or prefixes/suffixes. That is, words like "in", "on", "at", and "by", or even (I'm not sure if these count), "from", "far from", "into", "within", etc. On one level, they seem like a "closed class" of words, in that they don't seem to be adding any more words like these, but on the other hand, as a concept it seems like those words don't capture all the possibilities of what you might want to say about location. For example, you might want to say (which you can in English with many words):
He was just about on the top of the table.
He was way down below on the bottom side of the bridge.
That is, "just about on" is saying "on" with a bunch of modification of the scope of its meaning. So that makes me wonder, why is "on" such a specially treated word, given that you have to have the freedom to greatly modify it with extra words.
I am thinking about it almost like a SQL query:
"they had" location = table
where position = just about on
I don't know, I still used the word on, because it is so ingrained in my head, but it is not a noun. Are there any languages where these sorts of locative words are nouns or verbs, or even adjectives? I don't know. But I am looking for more inspiration on these sorts of locative words (that wiki page is a good start I guess).