SQL Queries for SharePoint lists and document libraries.
BPC SQL Query Builder is a SharePoint web part that provides automatic generation of ready-to-run sql queries for Sharepoint custom lists and document libraries. The resulting query can be used by custom applications for fast Sharepoint data retrieval, or in various reporting engines (such as SQL Server Reporting Services).
The generator supports automatic joining of related lists (lookups) for showing both name and ID values, multi-lookup information concatenated into a single row (multiple values are shown in comma-separated mode),“person or group” field types and generation of SQL queries for choice fields.
The web part has a built in Test Query feature so that you can check query results and make changes on the spot without the need to use your SQL Server tools.