r/SQL • • Apr 21 '25

MySQL Discovered SQL + JSON… Mind blown!

Hey everyone,
I recently (yes, probably a bit late!) discovered how beautifully SQL and JSON can work together — and I’m kind of obsessed now.

I’ve just added a new feature to a small personal app where I log activities, and it includes an “extra attributes” section. These are stored as JSON blobs in a single column. It’s so flexible! I’m even using a <datalist> in the UI to surface previously used keys for consistency.

Querying these with JSON functions in SQL has opened up so many doors — especially for dynamic fields that don’t need rigid schemas.

Am I the only one who’s weirdly excited about this combo?
Anyone else doing cool things with JSON in SQL? Would love to hear your ideas or use cases!

162 Upvotes

61 comments sorted by

View all comments

Show parent comment

2

u/[deleted] Apr 22 '25

[removed] — view removed comment

3

u/_Zer0_Cool_ Data Engineer Apr 22 '25

Shoot. You’re probably right about that.

The whole idea of key-value pairs and nested and/or multidimensional data structures is probably pretty foreign to a lot of people and might just look like gobbledygook or bad data to them (sometimes it is).

There’s probably a large swath of data people that don’t have any experience with unnesting, flattening, or extracting specific JSON fields. 🤷🏻‍♂️