Table Sql

Enhance the Moodle tablesql-class by advanced features and responsive technology
Enhanced table_sql functionality with advanced features and a modern, responsive interface
Moodle provides a table_sql class for building tables through a unified API. However, it lacks modern features such as AJAX-based pagination and filtering.
local_table_sql is a drop-in replacement for Moodle’s core table_sql class and adds a wide range of powerful enhancements, including AJAX navigation, full-text search and advanced filtering for each column.
Plugins can declare this plugin as a dependency in their version.php . Tables built using local_table_sql provide the following features:
Key Features
AJAX-driven data loading – Load only the data that is needed, improving performance.
Built-in filtering and sorting – Global search or column-specific filters included.
Full-text search support
Dynamic column visibility – Show or hide columns instantly.
Customizable UI actions – Add action buttons or context menus for each row.
Row selection and bulk actions
SQL-based data source – Provide your own SQL query as input.
Custom form integration – Display forms for adding or editing rows.
Usage
See the demo folder for example usage of the  local_table_sql plugin.
Information for developers regarding the react-app directory
The  react-app directory contains the React frontend responsible for rendering table data, built using Material React Table .
To build the React app (only needed if you made changes to the react code, a precompiled version is included in the plugin):
Run the script: