Is there a way of evaluating the 'default' expression for a table in a context other than INSERTing a new row?
### Example:
```
create table people(name text default 'fred');
insert into people default values; -- will insert 'fred'
insert into people values(null);
```
I am wondering if there is some construction that would allow me to generate the row - without actually necessarily persisting it - in the same way?
```
select ifnull(name,'I would like the default here') from people;
```
I can see how to *see* the expression; so for static strings , you can do this:
```
SELECT TRIM(dflt_value,"'") -- bad assumption
FROM pragma_table_info('people')
WHERE NAME='name'
```
The TRIM here is to remove the single quotes from the default; but that only works of course if the default happens to be a static string, rather than a calculated one.