Open LMS has an SQL editor from which you can run queries against the database. To access the SQL editor, use the administrator credentials and access the system's home page. From there, click the gear icon in the upper-right corner and click Home page settings > Reports > SQL Manager.

Enter or paste the SQL code into the designated box and click Generate report. The results of the query will appear at the bottom of the page in a paginated table, and you can download them by selecting either CSV or XLS under Export.

You can save the query for later use by assigning it a name and clicking Save query. In the future, you can retrieve saved queries using the Saved queries button.