Without looking at the code I can’t quite guess what’s going on. If the urls that you are referring to are the category and topic urls, then yes, they are created automation, but it sounds like the script generates the category, topic, and posts separately, so the left hand doesn’t know what the right hand is doing.
If that’s the case, you’d need to run the category creator, then put the category path in the topic creator, then put those topic paths in the post creator? If you want them all in one category, then you should use just the one url for that.
It’s hard for me to imagine that the sql is more of a mess than the csv, but sometimes I don’t have a very good imagination.