How could I adjust the line length for foreign keys to make them inline in create table statements?

[nathanchapman]

e.g. when printing with pretty=True

parsed.sql(pretty=True, dialect="mysql")

output:

CREATE TABLE IF NOT EXISTS `analytics_player_insight` (
  `id` BIGINT NOT NULL AUTO_INCREMENT PRIMARY KEY,
  `uuid` VARCHAR(36) NOT NULL UNIQUE,
  `player_id` BIGINT NOT NULL,
  `metric` VARCHAR(100) NOT NULL,
  `value` DECIMAL(10, 2) NOT NULL,
  `date_created` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP(),
  `date_updated` DATETIME DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP(),
  FOREIGN KEY (`player_id`) REFERENCES `player` (
    `id`
  )
)

is there a way to inline the foreign key? e.g.:

CREATE TABLE IF NOT EXISTS `analytics_player_insight` (
  `id` BIGINT NOT NULL AUTO_INCREMENT PRIMARY KEY,
  `uuid` VARCHAR(36) NOT NULL UNIQUE,
  `player_id` BIGINT NOT NULL,
  `metric` VARCHAR(100) NOT NULL,
  `value` DECIMAL(10, 2) NOT NULL,
  `date_created` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP(),
  `date_updated` DATETIME DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP(),
  FOREIGN KEY (`player_id`) REFERENCES `player` (`id`)
)

I tried using max_text_width=120 but it didn't seem to work

I couldn't find much else in the docs so thought I'd ask here for help. Thanks in advance!

[georgesittas]

This isn't possible without overriding the generator class. You could do this in your application and make the following override.

    def schema_columns_sql(self, expression: exp.Schema) -> str:
        if expression.expressions:
            expressions = self.expressions(
                expression,
                dynamic=True,
                new_line=True,
                skip_first=True,
                skip_last=True,
            )
            return f"({expressions})"
        return ""

[nathanchapman]

@georgesittas thank you so much!!