Reading large data in R using the duckdb package. You can choose to set your own delimiter: you are not restricted. e.g.,(",", ";"). This is easy when working with large data files.
Source: https://www.appsilon.com/post/r-one-billion-row-challenge
In python, you can connect duckdb with your database even with no data. It is an easy and lightweight way to analyze data consistently.