Re:Ask HN: Creating a query builder for end users
by shebson on Saturday April 19, 2014 @03:07PM
(#7614359)
You shouldn't trust it just because of your UI. With developer tools, regardless of your UI, it would be trivially easy for a malicious user to send any arbitrary SQL query. This would allow them to retrieve sensitive data or modify/delete records from your production database. You really should only build this query server-side, and, as the OP is using PHP, I should also add the caveat that they should use PDO.
Interesting point. Can't you get around this by only exposing certain tables/fields in the UI based on the users permissions?