{description: 'Retrieves each patient''s most recent address in a given city. Includes two\ndialects for the same logical query.\n\n**Standard SQL:**\n```sql\nWITH ranked_addresses AS (\n  SELECT\n    patient_view.id AS patient_id,\n    patient_view.name,\n    patient_address_view.address_line1,\n    patient_address_view.city,\n    patient_address_view.state,\n    patient_address_view.postal_code,\n    patient_address_view.updated_at,\n    ROW_NUMBER() OVER (\n      PARTITION BY patient_view.id\n      ORDER BY patient_address_view.updated_at DESC, patient_address_view.address_id DESC\n    ) AS address_rank\n  FROM patient_view\n  JOIN patient_address_view\n    ON patient_view.id = patient_address_view.patient_id\n  WHERE patient_view.active = true\n    AND patient_address_view.city = :city\n)\nSELECT\n  patient_id,\n  name,\n  address_line1,\n  city,\n  state,\n  postal_code\nFROM ranked_addresses\nWHERE address_rank = 1\n```\n\n**PostgreSQL dialect:**\n```sql\nSELECT DISTINCT ON (patient_view.id)\n  patient_view.id AS patient_id,\n  patient_view.name,\n  patient_address_view.address_line1,\n  patient_address_view.city,\n  patient_address_view.state,\n  patient_address_view.postal_code\nFROM patient_view\nJOIN patient_address_view\n  ON patient_view.id = patient_address_view.patient_id\nWHERE patient_view.active = true\n  AND patient_address_view.city = :city\nORDER BY patient_view.id, patient_address_view.updated_at DESC, patient_address_view.address_id DESC\n```', package_name: hl7.fhir.uv.sql-on-fhir, name: UniquePatientAddressesQuery, type: '{:coding [{:system \"http://hl7.org/fhir/uv/sql-on-fhir/CodeSystem/LibraryTypesCodes\", :code \"sql-query\"}]}', package_version: 3.0.0-ballot, class: unknown, kind: null, url: 'http://hl7.org/fhir/uv/sql-on-fhir/Library/UniquePatientAddressesQuery', version: 3.0.0-ballot}