Review read_sc_extract_xxx for reading from the social care platform

[Jennit07]

Currently, we use this:

  at_full_data <- dplyr::tbl(
    sc_dvprod_connection,
    dbplyr::in_schema("social_care_2", "equipment_snapshot")
  ) %>% dplyr::collect()

and then we do a selection on the variables but this takes too long in targets ~23 minutes. We should try change this to use SQL for selecting variables while we read from the platform to speed this up

[github-actions]

This issue is stale because it has been open approximately 5 months with no activity.