I haven't used SharePoint a great deal, but I have worked with other database systems.
If I have a table in a SharePoint site, how can I connect to it and issue a database query in a similar fashion to how you would do this on MySQL etc? I can find the button to load a SharePoint table in Microsoft Access, so presumably this is possible if I could find the URL to connect to. I'd like to do this to integrate the data held in sharepoint with a workflow tool which can query Databases and produce a report, or ideally post new data back into the database.
I can find resources for how to connect SharePoint to other external databases, but how do you connect to the SharePoint backend database itself?