I am yet to find a replacement for R's dbplyr in Python. Read: Python-to-SQL code generation (dbplyr performs R-to-SQL). This is a very powerful package that alone can make me stay in R.
Ibis would be the equivalent of unified frontend for tabular data. It was created by the Wes McKinney, also Pandas creator, that now works in Posit (old RStudio).