What are the solutions for granting the user access to the database?

Question

Python

I have a python program using Django ORM. which collects proxies, checks and saves them in the database along with various data about them. I want to make an API for accessing the database so that users can send requests like:

"from proxy get url where uptime < {} and !badProxy order_by uptime".format(time.time() - 300)
# uptime is time when proxy starts to work last time

Either like this:

{
  'table': 'proxy',
  'fields': ['url',],
  'filter': AndFilter("!badProxy", "uptime < {}".format(time.time() - 300)),
  'order_by': ['uptime'],
}

Ideally, these queries should be translated into sql (naturally, there should be protection against sql injections) and at the same time it should be possible to set access rights so that it is impossible to look at service tables, do drop databases, etc.
Of course, you can write it yourself, but suddenly there is some ready-made good solution.

Answer 1

www.django-rest-framework.org