terracatta
select *, (select true from file where path = apps.path || "/Contents/_MASReceipt") as from_app_store from apps where from_app_store=1;