In the FAQ[1] it explicitly states that it cannot help you code. Maybe that's a limit of the prompt or just a limit of Google using a smaller/cheaper model? We'll have to test it out to see.

[1]: https://bard.google.com/faq