You can checkout opensource project Rowyhttps://github.com/rowyio/rowy - it a spreadsheet UI for database and can do databasy things like you said!
formulas but in JS/TS, on data change trigger of serverless cloud functions, assign default values for database columns, granular permission controls, store files/assets images to cloud storage, bulk deletes and more.
Disclaimer, I am one of the makers :)