Core - Add support for materialization of transforms in parquet format

## What feature do you want?
Add the ability to make tables materialize to parquet.

## Expected Implementation Idea
Look into editing the Transform class, specifically the `compile_sql` and `apply_node` functions

## Component
- [x] Core (Mention which core component)
- [ ] CLI client
- [ ] Other

## Additional Context
Please add support for reading from parquet files too