I believe rows have metadata (createdAt, modifiedAt, etc).
I’m imagining an extension where the right panel lets me add or modify custom metadata / attributes. Perhaps even a strongly-typed system to back it.
Is something like this possible with extensions? I could/should prove Claude for this, but figured it would be more direct to post here!
Yes, rows can have arbitrary key=value attributes. The created/modified ones are a bit special case. The generic ones are all eventually stored in [String : String] dictionary. Extensions, cli, AppleScript can all read/write these attributes as they like.
There is no type system for this. I have thought it would be nice to have a standard set of typed attributes, but haven’t got to that yet, and don’t expect too think about it soon. But if you’ve got thoughts, feel free to let me know.
So yes, something like what you propose should be possible. You should talk to @complexpoint, I think he was working on something similar.