Please correct me wherever I’m wrong! It’s potentially a bit of a muddle of versions! It’s just what I’ve compiled over the last year with various versions!

there are some odd edge cases, especially when properties are inside properties. the one i can remember is a Repeatable textstring is a newline seperated list on it's own an a json array when its inside a block list 😟

Contentment datalist could be a good addition, it saves it as a json array of values -

["val1", "val2"]

You could also consider adding a note on how to find this out for yourself if you need to. I always end up just going in and creating the property and saving a value on a node then finding the saved value in the umbracoPropertyData table. Not to create a lot of extra work for you 😄 This is very nice and useful!

I agree @Jemayn it would be good to give an example SQL query to be able to find it for a specific node and property

I've got a very good one I use all the time - was pondering a blog/Skrift post on it recently since we were chatting about it at ProWorks.