How to allow users to enter SQL queries?

Question

PHP

Something like sql-ex. The database is a test one, users can see any data from it, but cannot delete anything (it is decided by restrictions on the user from which requests are made).
In general, what is the best way to send queries to the database in this case? Directly or through some handler. If through it, what to process?

Answer 1

The specific solution depends on the DBMS. In general, it seems that all full-fledged DBMS allow you to configure user rights in a fairly wide range, and in yours you can probably allow INSERT and UPDATE (by the way, in case of catastrophic updates, you still need to make backups), prohibiting DELETE (and at the same time do not forget to prohibit DDL subset operators , otherwise someone will be able to bang you the entire table or a separate column, for example).
Further depends on the training of users - sometimes the SQL command line is really the most convenient shell for working with data, but these days, few people except programmers know how to use it.