Path to database file is not relative to the file calling it?

In the project X-Press Publishing, the README file says:

Note: When loading database.sqlite in your JavaScript files, sqlite3 will always try to load database.sqlite from the root directory path, ./database.sqlite, regardless of where the current file is located. Therefore your code will always be new sqlite3.Database(process.env.TEST_DATABASE || './database.sqlite') regardless of the file you are writing in

Does this mean that I should not try to create a database file in any other directory other than the root?
Can you further expllain why sqlite works this way?

Thanks,