DEV Community

Discussion on: SQL Queries to Complex JSON Objects

Collapse
 
patarapolw profile image
Pacharapol Withayasakpunt • Edited

Thanks for the example, but I am concerned about one thing in SQL -- SQL keywords clashes with table / column name. How do I ensure that the column names are safe to use?

NVM -- Found the guide.

Another consideration is still, no prepared statement? How to prevent SQL injections? I am especially concerned about escaping backticks and [].