Feature Request: Manual Table Configuration and Association

[ethanpil]

QueryTree is an amazing piece of work! Thank you. I have two requests which would be so helpful in cases where we don't want users to have full visibility of the database and in cases where AutoJoin wont work because we have foreign keys which are not defined in the table.

In appsettings.json I would love to be able to:

Grant permissions for the tables which users will have access to.

(Would be great with wildcard or regex)

"TablesAccess": {
    "*": false,
    "users*": false,
    "products": true,
    "orders": true,
    "customers": true,
    "vendors": false
  }

Ability to define a field within a table as a foreign key from another table

"TableJoins": {
    "products": {
        "categoryid": {
            "table": "categories",
            "field": "categroyid" 
         }
     },
    "orders": {
        "customerid": {
            "table": "customers",
            "field": "customerid" 
         }
     },
    "order-items": {
        "orderid": {
            "table": "orders",
            "field": "orderid" 
         },
        "productid": {
            "table": "products",
            "field": "productid" 
         },
     },
  }

[stale]

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions.