Database agnostic auditing
Triggers make an auditing mechanism, that satisfies your criteria.


they are present in the ISO/ANSI standard (ISO 9075)
they can be used to track row-level changes
they can save data to tables, hence can be queried using SQL


Only thing I do not understand in your question is "database agnostic" - what does it mean, precisely?