We have an item suiteql query. We have a custom document field, which can not be accessed through suiteql. Do you have any workaround to get to the URL of the file from SuiteQL?

Create a text field, which stores the media item id of that document.. Use that field for your query.