How can I retrieve the library version number?

[tetsuhaut]

Hi,
I would like to mention the library version number in my CMakeLists.txt file so I can ask my users to install a specific version of your library.

I tried

find_package(SQLite3 REQUIRED CONFIG)
target_link_libraries(mainLib PRIVATE SQLite::SQLite3)
message(STATUS "SQLite3 version=${SQLite3_VERSION}")

to no avail, the variable ${SQLite3_VERSION} is empty. Though I can see in your project

project(sqlite3
    VERSION   3.49.2
    LANGUAGES C
    HOMEPAGE_URL "http://www.sqlite.org"
)

Is there a way to get that version ?

Thanks