The Query Builder allows plugin users to execute any SQL command (DCL, DDL and DML) from the WordPress dashboard, as long as the user has the necessary credentials. The tool is available for admin users only and restricts access to WordPress tables. Multiple queries can be edited simultaneously. Queries can be stored per WordPress user account and can be reused at a later time. Output can be exported to CSV, JSON and XML. The Query Builder lets a plugin user access local as well as remote databases. The raw server response can be examined for further research.
Is it possible to create a search box on the front-end (i.e., on the website) in which users can input sql command instead of a keyword based search box?
Hi Ian,
It is possible but too risky. WordPress uses one user account to connect to the database. That user account can access all tables in your WordPress database. If you give website visitors access to sql, you give them accesss to your WordPress tables…
For publications you might consider the search builder. The search builder has some restrictions but allows visitors to create field based queries. A demo can be found here:
https://wpdataaccess.com/search-builder-demo/
Hope this helps,
Peter