fix(sqlite): retain fast COUNT and add D2 qualification checks

fix(sqlite): retain fast COUNT and add D2 qualification checks #5579