SQL Query

I can see that the query builder translates the script into SQL before sending it to get data, why not add an option to let users generate their own SQL query to run rather than having it built for them?

  • Russ Sturgeon
  • Apr 15 2025
  • Reviewed: Voting Open
  • Attach files
  • James Belich commented
    22 Apr 14:57

    The ability to run custom SQL queries against the back-end databsae would be the single most useful thing Blackbaud could add to RE! At previous organizations, most of what I did as database manager was based on SQL queries (list pulls, data checks, etc.). My current position is the first time I haven't been able to query the back-end database directly, and as a result most tasks take longer. The Query tool can do a lot, of course, but nothing can match the flexibility of being able to design complex queries EXACTLY how we need to!