Learn What is Magic Tables in SQL, magic tables are used when we wan to perform any activity after any DML operation is performed on the table, basically it is used in Triggers in SQL SERVER
You will require need to get the data from SQL table in JSON format, so read an article to know how to get SQL Table data into a JSON format instead of simple table format.
Difference between SQL and NoSQL, SQL is structured Query Language, NoSQL is non-relational Database which stores data in Key-Value pair, Graph and in Documents where SQL stores data in tables