bug: loosing required type when using to_pyarrow

[christophediprima]

What happened?

When using to_pyarrow on a Ibis expression the required types are lost. Here is an example to reproduce it:

import ibis

ibis.options.interactive = True

schema = ibis.schema([
  ('id', '!string')
])

new_ids = ibis.memtable([{
  'id': 'my_id',
  }]).cast(schema)

print('--- ibis exp ---')
print(new_ids)
pyarrow_df = new_ids.to_pyarrow()
print('--- pyarrow_df ---')
print(pyarrow_df)
print('--- pyarrow_df after recasting ---')
print(pyarrow_df.cast(schema.to_pyarrow()))

Using things like ibis.literal('my_id', type=ibis.dtype("string", nullable=False)) to set the value won't fix the issue.

What version of ibis are you using?

10.0.0

What backend(s) are you using, if any?

No response

Relevant log output

--- ibis exp ---
┏━━━━━━━━━┓
┃ id      ┃
┡━━━━━━━━━┩
│ !string │
├─────────┤
│ my_id   │
└─────────┘
--- pyarrow_df ---
pyarrow.Table
id: string
----
id: [["my_id"]]
--- pyarrow_df after recasting ---
pyarrow.Table
id: string not null
----
id: [["my_id"]]

Code of Conduct

• I agree to follow this project's Code of Conduct

[cpcloud]

Thanks for the issue, PR to fix it is up at #10897.