"When" column should be renamed for compat

[Wardormeur]

"when" column seems to break seneca-sqlite-store.
Considering "when" is a reserved SQL keyword, another name would be welcome to avoid such issue :)

[indr]

What about... createdAt, modifiedAt... or even better.... createdAtUtc, modifiedAtUtc etc.

[mcdonnelldean]

Is this coming from entity or specifically from seneca-user? I agree with @indr's suggestions. Thoughts @mihaidma

[augustine-tran]

+1
I got the same with PostgreSQL

[mihaidma]

the seneca-sqlite-store needs to have its code replaced with the seneca-standard-store plugin. This is used by both postgres and mysql. All store fixes will go now into the standard-store plugin as it fixes all stores.

[mihaidma]

I'll close this and open an issue on both standard-store and sqlite store. I think this is more like a bug related to escaping the column names.