Lombiq/Orchard-Data-Tables

Create an SQL Query based provider (OSOE-337)

Opened this issue · 0 comments

Implement an IDataTableDataProvider that lets the user create a custom table using parameterized SQL Queries without coding.

Context from here:

Would it be feasible to provide a basic general provider for Queries that you can use without writing any code (like on DotNest)?

Yes, but I think you'd have to implement some kind of column definition content type with custom editor to provide the human readable column names so it wouldn't be that trivial. Also have to think about the security aspect of user provided SQL queries.

Jira issue