For the Java ecosystem, H2 fills this gap nicely, easily handling both in- memory and remote JDBC access:
https://frequal.com/java/TheBestDatabase.html