Hi arushigulati,

I encountered the same issues when I was attempting a similar POC between Oracle and Databricks SQL / Python. I found it could cover a good ~80% of what was fed through out of the box but would not always cover the specific SQL flavor or how the original script author formatted their code. 

To get around this I ended up writing a custom configuration for Bladebridge. Within this I would;
Inherit the original oracle base config that the out of the box product uses (base_oracle2databricks_sql.json) and then write my customization on top.

Based on your specific issue, you could try and follow the section around line_subst for your specific customization need on primary key.

Once you are done make sure to re-run the install-transpile command and reference the path of your new config (example from linked documentation)

databricks labs lakebridge install-transpile
Do you want to override the existing installation? (default: no): yes
Specify the config file to override the default[Bladebridge] config - press <enter> for none (default: <none>):
my_custom_config.json