FireDAC и иже с ним. Работа с SQLite

 select * from table1

select * from table2 where table2 .id2 =:ID1

select * from table3 where table3 .table2_id2 =:ID2

SELECT group_concat(temptable1.ID_MainTableNAME) AS ID_MainTableNAME,
       group_concat(temptable1.STRVALUE_MainTableNAME, ' + ') AS STRVALUE_MainTableNAME,
       sum(temptable1.HINT_MainTableNAME) AS HINT_MainTableNAME,
       group_concat(temptable1.ID_MainTableClass) AS ID_MainTableClass,
       group_concat(temptable1.STRVALUE_MainTableClass, ' + ') AS STRVALUE_MainTableClass
  FROM (
           SELECT MainTable.ID AS ID_MainTableNAME,
                  MainTable.Name AS STRVALUE_MainTableNAME,
                  (CASE WHEN MainTable.Description ISNULL THEN 0 ELSE 1 END) AS HINT_MainTableNAME,
                  group_concat(MainTable_Classes.Class) AS ID_MainTableClass,
                  group_concat(Catalog_Classes.Name, ', ') AS STRVALUE_MainTableClass
             FROM MainTable
                  LEFT JOIN
                  MainTable_Classes ON MainTable.ID = MainTable_Classes.ID_Main
                  LEFT JOIN
                  Catalog_Classes ON MainTable_Classes.Class = Catalog_Classes.ID
            GROUP BY ID_MainTableNAME
       )
       AS temptable1
       INNER JOIN
       (
           SELECT ResearchTableAnchorMainTable.ID_MainTable AS ID_MainTableNAME,
                  ResearchTableAnchorMainTable.ID_RTAdapter AS ID_ResearchTableAdapterNAME,
                  ResearchTableAdapter.ID_ResearchTable AS ID_LOCK_ResearchName,
                  (CASE WHEN ResearchTableAdapter.Link ISNULL THEN 0 ELSE 1 END) AS STRVALUE_ResearchTableAdapterLink
             FROM ResearchTableAnchorMainTable
                  INNER JOIN
                  ResearchTableAdapter ON ResearchTableAdapter.ID = ResearchTableAnchorMainTable.ID_RTAdapter
       )
       AS temptable2 ON temptable2.ID_MainTableNAME = temptable1.ID_MainTableNAME and ID_ResearchTableAdapterNAME = :ResearchTableAdapterNAME
 GROUP BY temptable2.ID_ResearchTableAdapterNAME;