Draw and query data from sqlite database in QGIS

First I am new to both QGIS and sqlite, I have some shapefiles and i load them to an spatialite database and i can work fine.My problem is i have another data in form of many tables in an sqlite database, it doesnt have a geometry just simple sqlite database, i thought i could bring in this database in QGIS and then define (X & Y) and coordinate system, but everytime i try to connect to it, i get an error (Unexpected error when working with (.....)).

i can add it as a vector layer and it show as tables but i cant visualize it im map canvas.

can you please help me ?

Thanks in advance