Android 9 where are SMS stored please? What is the path?
As mentioned by @alecxs, the sms are stored in the database: " /data/user_de/0/com.android.providers.telephony/databases/mmssms.db" which need root privileges to access it or edit it.
If you don't have root access, you can interact with the table
sms in this database using ADB:
list all SMS
adb shell content query --uri content://sms
list SMS from +2121212121
adb shell content query --uri content://sms --projection address:date:date_sent:body --where 'address=+2121212121'