Unspecified table dolt diff and dolt_history should show the history of all the tables per commit

[timsehn]

User wanted something akin to git log -p --name-only but in SQL.

Seems like an unscoped dolt_history table would be useful.

something like:

select * from dolt_history;

table, commit_hash, committer, commit_date
table1, abcd, tim, 'feb 2, 2022'
table2, abcd, tim, 'feb 2, 2022'
table1,wxyx, tim, 'feb 1, 2022'

I'm not sure this gets exactly what he needs. This would allow you to see tables added and removed.

Maybe unscoped dolt diff? From the above, it would look the same but would imply each table changed in both those commits. Imagine there was a table 0 that did not change.

select * from dolt_history;

table, commit_hash, committer, commit_date
table0,  abcd, tim, 'feb 2, 2022'
table1, abcd, tim, 'feb 2, 2022'
table2, abcd, tim, 'feb 2, 2022'
table1,wxyx, tim, 'feb 1, 2022'
table0, wxyx, tim, 'feb 1, 2022' 

select * from dolt_diff

table, commit_hash, committer, commit_date
table1, abcd, tim, 'feb 2, 2022'
table2, abcd, tim, 'feb 2, 2022'
table1,wxyx, tim, 'feb 1, 2022'
table0, wxyx, tim, 'feb 1, 2022'