I often want to enter the current date in a new table record. I know that this can be done with an "ALTER TABLE" SQL statement, but it is undocumented (and may well have different syntax in different database backends) and does not appear in the "Default" entry in the Table|Edit window. At the very least, put the default into the Table|Edit window. It's available in the Information Schema, at least in HSQLDB.
From memory, this was a feature that previously existed in OpenOffice.org 1.x and was removed by Sun at the time because people got annoyed with it, i.e. there was a sufficiently large amount of users that hated having to delete/overwrite the default today date in order to enter the date they actually wanted. So, in the meantime, we have lived without this feature for more than 10 years and workarounds have been developed (mostly macro based) to implement the same functionality on a case-by-case scenario. Personally, I would be in favour of such a feature, but as I'm not the one writing the code I'll mark it as feature request for enhancement and see what others think.