Is there any good way of imitating the UrlRewrite implementation with a regular SQL query? See when you look in tblContentLanguage, it only contains LinkURL which is basically just /link/hash. Can you get the friendly URL by query in any good/reliable way? The only obvious thing I've seen so far is to build it by URLSegment from parents + child as well as the LanguageId (becomes e.g. /en/parent/parent/child).
My reason for doing this is simply because I'm trying to read the full tree structure with all page information through an SQL connection in python, the project is not allowed to use any EPiServer dependency - so I can't just make the python app call a C# app which uses EPiServer's API.
I'm thankful for suggestions,
The easiest way I can think off my head is to make your own RESTful API in your episerver project, so you can call the API from your python app.