Feature auto infer orient as table or split in read_json
- [x] closes #52713
- [x] [Tests added and passed]
- [x] All [code checks passed]
- [ ] Added [type annotations](https://pandas.pydata.org/pandas-docs/dev/development/contributing_codebase.html#type-hints) to new arguments/methods/functions.
- [x] Added an entry in the latest `doc/source/whatsnew/vX.X.X.rst` file if fixing a bug or adding a new feature.

### Example:

This example demonstrates how to use the updated functionality of `read_json` to correctly handle the new `orient='table'` format.

#### Saving DataFrame to JSON with orient='table':

```python
import pandas as pd

# Create a sample DataFrame
df = pd.DataFrame({"A": [1, 2, 3]})

df.to_json('test.json', indent=1, orient='table')
read = pd.read_json('test.json')
print(read)

   A
0  1
1  2
2  3
```

#### Saving DataFrame to JSON with orient='split':

```python
df = pd.DataFrame({"A": [1, 2, 3]})

df.to_json('test.json', indent=1, orient='split')
read = pd.read_json('test.json')
print(read)

   A
0  1
1  2
2  3
```
I am also generally -1 on this feature. We've tried to move toward explicit behaviors over time, and inferencing goes against explicitness. Hi @mroeschke 
Oh alright. Thanks for the interest in a PR @chandra-teajunkie , but from the discussion I don't think this is one we will move forward with Thanks for the feedbacks!