feat: add some `SparkLikeLazyFrame` methods #5327

Job	Run time
pytest-38 (3.8, windows-latest)	1m 41s
pytest-windows (3.10, windows-latest)	5m 27s
pytest-38 (3.8, ubuntu-latest)	1m 18s
pytest-windows (3.12, windows-latest)	3m 7s
pytest-full-coverage (3.9, ubuntu-latest)	2m 50s
pytest-full-coverage (3.11, ubuntu-latest)	3m 7s
pytest-full-coverage (3.13, ubuntu-latest)	2m 41s
	20m 11s

Provide feedback