This needs more than a pinch of “it depends” and “know what you are doing”, but “always” asserts also have their place: The Use Of assert() In SQLite
(to clarify, this statement has zero bits of information related to Bun, and deals exclusively with design space around assertions 
)