> In fact, any database is more complex than a text file.
This statement is true, at a very superficial level. But it is missing all the nunace that goes into why would someone be using this file.
Are you comparing opening a text file in a text editor vs. opening the db.sqlite file in a text editor? Yes, of course the text file is more usable.
But what is the use case of just staring at the file? I can't imagine any.
If you are someone who wants to programmatically use the contents of that file (outside gnucash application), surely you are writing code to process the data. And thus, being able to use SQL is massively more convenient.
This statement is true, at a very superficial level. But it is missing all the nunace that goes into why would someone be using this file.
Are you comparing opening a text file in a text editor vs. opening the db.sqlite file in a text editor? Yes, of course the text file is more usable.
But what is the use case of just staring at the file? I can't imagine any.
If you are someone who wants to programmatically use the contents of that file (outside gnucash application), surely you are writing code to process the data. And thus, being able to use SQL is massively more convenient.