[mcny]

How do you query json with SQL server like let's say you have one data point like this

{ "id": 42, "quantity": 12, bla bla bla

And you want rows where this column has quantity and quantity ≥ 20

How do you do it if you encode everything as base 64?

[isoprophlex]

You slap a full text index on the base64 string. There's only a finite number of base64 substrings for the un-encoded substrings "id", 42, etcetera, so you first filter on those. Then you decode those full strings into json and do the final filtering application side. Easy!

[6510]

<joking>have col names id, quantity, json and greaterthan20

[thih9]

This is only a joke until a manager hears it. Then it’s part of the Q1 roadmap and we will refactor it in Q3.