Hi @viralpatel ,

Yep, Lakebridge is not perfect so far. There are several open issues at github related to Synapse and Lakebridge.
Regarding second question, I guess you can try to build your custom transpiler setup. The code is open sourced and available below:

lakebridge/src/databricks/labs/lakebridge/transpiler at main · databrickslabs/lakebridge

But before you do that, maybe take a look at customizing bladebridge transpiler with your own custom rules?
Bladebridge transpiler relies heavily on rules defined inside configuration files provided with the converter. These configurations are comprised of a set of layered json files and code templates that drive the generation of output files and application of conversion rules. 
So maybe you will be able to improve quality of translation by defining your own set of custom rules (which should be a lot easier than crafting your own transpiler from scratch)

lakebridge/docs/lakebridge/docs/transpile/pluggable_transpilers/bladebridge_configuration.mdx at mai...

Also, you can rais an issue and describe this bug here:

Issues · databrickslabs/lakebridge