You are right, sqlite is public domain and I fell victim to some echoes in my mind from the early days of the open source licencing theorizing when "pubic domain is not" was an important talking point, but I guess the thing public domain was not is compyleft (or one of its mostly overlapping siblings), not open source, the superset of everything not closed.