Is there a way to set the max_width so that printed dataframes are always shown with that option

[zero-stroke]

Similar to how in pandas you can do
pd.set_option('display.max_columns', 20)
or
pd.set_option('display.width', 200)

and then it doesn't ever have to be updated again since it persists, is there a way to do that for the way that duckdb dataframes are shown?

e.g.,

duckdb.set_option(max_width=250)

with duckdb.connect(Paths.DUCK_DB) as conn: 
    df = conn.sql('select * from my_table order by timestamp')
    
    # not necessary df.show(max_width=250)
    df.show()

print('doing other example operations...')

with duckdb.connect(Paths.DUCK_DB) as conn: 
    df = conn.sql('select * from my_table order by timestamp')
    
    # not necessary df.show(max_width=250)
    df.show()

[evertlammerts]

You can set it once by wrapping show: _show = duckdb.DuckDBPyRelation.show and then duckdb.DuckDBPyRelation.show = lambda self, **kw: _show(self, **{"max_width": 250, **kw}). That covers every rel.show() call, and an explicit max_width still wins; it does not change print(rel) or the plain repr. In Jupyter and marimo the relation already renders as an HTML table with every column. A proper setting is tracked in #65.