SQL Playground
TutorialsPlayground
SQL FormatterSQL MinifierSyntax ValidatorJSON to SQLCSV to SQLSQL to JSONER Diagram Generator
Daily ChallengeInterviewsCheat SheetBlog

© 2026 SQL Playground. Built for developers.

PrivacyTermsAboutRSS Feed
SQL Playground
TutorialsPlayground
SQL FormatterSQL MinifierSyntax ValidatorJSON to SQLCSV to SQLSQL to JSONER Diagram Generator
Daily ChallengeInterviewsCheat SheetBlog
Initializing...
Chapter 12: JSON in SQL
12-1
Your Progress

JSON Support

Modern SQL databases (including SQLite) support JSON data. You can store JSON in a text column and query it.

SELECT json_extract(data, '$.name') 
FROM user_logs;

Task: Extract the 'city' field from the attributes JSON column for all users.

Loading...
Run a query to see results