I want to transform this postgres code to pure python code $($i$.$e$.$ not using any SQL at all$).$ Please note, we can use any spatial analytics python library that we want. Here is the code $-$ select

p$.$imei,

st$\_$transform$($p$.$"geoJson", $32643)$ as geom,

"generatedAt" as t$,$

p$."$ID$"$ as u$\_$ping$\_$id

from

campaign$\_$pings p

where $--$"createdAt"::date $=$ d$\_$date$--$d$\_$date

"generatedAt"$+$ interval $\text{'}5$ hours' between start$\_$time$\_\_$ and end$\_$time$\_\_$

and

p$.$imei in $($

select

assets."IMEI"

from

campaign$\_$staff staff

left join campaign$\_$staff$\_$info csi on csi."campaignStaffID"$=$staff."ID$"$ and csi."date" $=($select max$($date$)$ from campaign$\_$staff$\_$info csi$2$ where csi$2.$"campaignStaffID" $=$ csi."campaignStaffID" and csi$2.$date $<=$ d$\_$date$)$

left join campaign$\_$staff$\_$assets csa on csa."campaignStaffID" $=$ staff."ID$"$ and csa."date" $=($select max$($date$)$ from campaign$\_$staff$\_$assets cs$2$ where cs$2.$"campaignStaffID"$=$ csa."campaignStaffID" and cs$2.$date$<=$d$\_$date$)$

left join campaign$\_$area$\_$assets caa on caa."assetID" $=$ csa."assetID"

and caa."campaignScopeAreaID" $=$ csa."campaignScopeID"

left join assets assets on assets."ID$"=$ caa."assetID"

left join staff$\_$type staff$\_$type ON staff$\_$type."ID$"=$ staff."staffTypeID"

left join campaign$\_$asset$\_$status cas on cas."campaignStaffID" $=$ staff."ID$"$ and cas."date" $=($select max$($date$)$ from campaign$\_$asset$\_$status cas$2$ where cas$2.$"campaignStaffID"$=$ cas."campaignStaffID" and cas$2.$date$<=$d$\_$date$)$

left join campaign$\_$scope cs on cs$.$"areaID" $=$ caa."campaignScopeAreaID"

where

caa."campaignScopeAreaID" $=$ areaid$\_$array$[$i$]$::uuid $--$areaid$\_$array$[$i$]$::uuid

and assets."IMEI" is not null

and staff$\_$type."ID$"=\text{'}93313048-4$e$75-4$e$91-9$bcd$-44897$a$6$df$7$c$7\text{'}--$ AIC ID

and $($cas$.$status is null or cas.status $<>$ 'DeployedWoPhone'$)$

and $(($csi$.$number is null$)$ or $($csi$.$number $<>\text{'}0\text{'}))$

and d$\_$date between cs$.$"campaignStartDate" and cs$.$"catchupEndDate"

$)$

$)$ u

left join $(--=================$ SELECTING child INFO $[$imei$,$ geom, generatedAt, pingID$]--=================--=================--=================--=================--=================$

SELECT

p$.$imei,

p$."$ID$"$ as a$\_$ping$\_$id$,$

st$\_$transform$($p$.$"geoJson", $32643)$ as geom,

"generatedAt" as t

FROM

campaign$\_$pings p

where $--$"createdAt"::date $=$ d$\_$date $--$d$\_$date

"generatedAt"$+$ interval $\text{'}5$ hours' between start$\_$time$\_\_$ and end$\_$time$\_\_$

and

p$.$imei in $($

select

assets."IMEI"

from

campaign$\_$staff staff

left join campaign$\_$staff$\_$assets csa on csa."campaignStaffID" $=$ staff."ID$"$ and csa."date" $=($select max$($date$)$ from campaign$\_$staff$\_$assets cs$2$ where cs$2.$"campaignStaffID"$=$ csa."campaignStaffID" and cs$2.$date$<=$d$\_$date$)$

left join campaign$\_$area$\_$assets caa on caa."assetID" $=$ csa."assetID"

and caa."campaignScopeAreaID" $=$ csa."campaignScopeID"

left join assets assets on assets."ID$"=$ caa."assetID"

left join staff$\_$type staff$\_$type ON staff$\_$type."ID$"=$ staff."staffTypeID"

left join campaign$\_$asset$\_$status cas on cas."campaignStaffID" $=$ staff."ID$"$ and cas."date" $=($select max$($date$)$ from campaign$\_$asset$\_$status cas$2$ where cas$2.$"campaignStaffID"$=$ cas."campaignStaffID" and cas$2.$date$<=$d$\_$date$)$

left join campaign$\_$scope cs on cs$.$"areaID" $=$ caa."campaignScopeAreaID"

where

caa."campaignScopeAreaID" $=$ areaid$\_$array$[$i$]$::uuid

and assets."IMEI" is not null

and staff$\_$type."ID$"=$ 'acf$0$cc$70-7$c$92-474$d$-82$af$-$f$37494$f$94$c$09\text{'}--$ Team ID

and $($cas$.$status is null or cas.status $<>$ 'DeployedWoPhone'$)$

and d$\_$date between cs$.$"campaignStartDate" and cs$.$"catchupEndDate"

$)$

$)$ a on ST$\_$DWithin$($u$.$"geom", a$.$"geom", $30)$

and a$.$t BETWEEN u$.$t $-$ INTERVAL $\text{'}30$ seconds'

and u$.$t $+$ INTERVAL $\text{'}30$ seconds'

where

a$.$imei is not null

$)$