Is it possible to create a column that has value auto-generated (by a callback) when a select query is performed?
Imagine I have a database containing entries storing timestamp/actionid/user
I want to make a select query :
select timestamp, user, actionid, [actionname]
from mytable
where user LIKE 'xxxx'
order by [actionname]
With the value of [actionname] calculated on the fly (by a callback executed in my code) during the query execution.
I know it is possible to make other table and an inner join, but I was wondering if such a process exits.
Cthat can be invoked by SQLite (see SQLite docs); not sure if or how easy it is to marshal this toC#.